Can filepro do drill downs like acess?

Jay R. Ashworth jra at baylink.com
Fri Mar 26 09:54:19 PST 2004


On Fri, Mar 26, 2004 at 10:19:48AM -0500, Bill Vermillion wrote:
> That's one reason they were developed. When these were almost
> standard for serious operations - sales for example - drives were
> not that reliable and hardware wasn't that stable - even the best
> of the HW.  These were all on Unix systems BTW.  Hard drives were
> about $4/megabyte if you shopped, or if vendor supplied were
> in the $8/megabyte range. [A far cry from the $1 Gigabyte 
> we see today for server strength IDE drives [ 50 cents or less for
> consumer/desktop drives].  The high-end high-capacity SCSI's are in
> the $6+ per GB.

Seagate's Cheetah-164 is about $800 right now.  That is, actually, $.50
a gig.

> So on boot a snapshot is made of the drive in it's current state.
> Multiple parallel fsck's are started in the background and the
> system is brought up for use.  Everything not fsck in the
> background is essentially in a read-only at this moment.
> 
> But if a user program needs access the blocks needed are
> essentially fsck'ed at that point.  IOW the fsck is prioritized to
> fsck blocks as needed. It will update the snapshot made at boot
> so these are now excluded from the background fsck.
> 
> In tests an fsck which might take 15-30 minutes if done at boot -
> even with parallel fscks running - when run in the background it
> could take 5+ hours.  But the system is avialbe immediately for
> use.

Actaully, mostof that is being done with journalling filesystems, these
days, which are effectively the application of transactions to
filesystem updates: the filesystem structure's sanity is preferred at
the expense of the data, in the event of a crash.

> > Row+Column locking? That could be handy. I think column locking
> > alone would be useless, but if you combined row and column,
> > that would be the ultimate. I wonder how much overhead that
> > generates though...
> 
> I don't know. For some reason I think this was in Oracle or
> one of their competitors at one time if not now. Overhead is
> not a problem - because in these instances the system has been
> optimized so that users don't remain idle waiting for someone
> else to finish with something they need to access. Once you
> exceed a certain number of users hardware and software costs
> become secondary to the costs of idle users.

You don't really *want* to do that, though; code tends to make an
assumption that a row is interenally consistant; allowing multiple
updates on parts of the same row without MVCC or something breaks that.

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Member of the Technical Staff     Baylink                             RFC 2100
The Suncoast Freenet         The Things I Think
Tampa Bay, Florida        http://baylink.pitas.com             +1 727 647 1274

        "They had engineers in my day, too."  -- Perry Vance Nelson


More information about the Filepro-list mailing list