> From: Andy Dent <[EMAIL PROTECTED]> > Date: Sun, 7 Jan 2007 19:39:51 +0800
>> Ethernet traffic would be a killer otherwise. > > Umm, not all engines are that limited. > > Whilst there aren't c-tree Plus bindings for RB, I can vouch for the > fact that the c-tree Plus ISAM engine's shared-file mode works > extremely well, as does the FoxPro shared file approach. > > My first use of c-tree Plus in shared-file mode was with a IIci as > server, using LocalTalk to Classics. Even with that hardware, it had > sub-second lookup times. For what size of dbs 0.5 - 5MB? and what kinds of queries? :-) > I'm not saying either of these engines is particularly useful in this > circumstance, although c-tree Plus could probably be compiled into a > plugin and used with RB, just correcting a misleading comment on > performance ;-) I shall argue up to a hoarseness, Andy :-) * yes, such dbs as Access and FoxPro, ad you mention c-Tree, which ARE oriented and designed for SHARED ACCESS of db files on server, will work better than engine which will stupidly pull all info into the client RAM. Such dbs as Access do use OS API to lock part of file. But MAIN POINT to keep in mind is that for example search by indexes do WHO? Right, the CPU of client computer. This means that N pages of index must travel by network to client computer, Where CPU will do searches, sorting, and so on. What is not pleasant here also, is that you move this N pages not as bulk, but one by one as N small requests to "server computer". You see? I think everybody know that it is MUCH faster move all at once, then by parts. So my point is that EVEN IF a DB engine is _optimized_ for shared access, this technique still a lots behind to client/server technique. Although I agree that if this way have work good for some projects in 90th on old hardware, then today even more projects can use it. -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
