Re: onKeyPress()
- Posted by George Walters <gwalters at sc.rr.com> Aug 06, 2001
- 441 views
I think all your points are good. I read from Rob's response that changing tables does in fact scan the entire file pulling 4 bites from each record... Here's a clip from his message dtd 8/6/01 db_select_table() reads in 4 bytes per record from the table Hopefully I am wrong on this... ..george ----- Original Message ----- From: "Jonas Temple" <jktemple at yhti.net> To: "EUforum" <EUforum at topica.com> Sent: Monday, August 06, 2001 11:42 AM Subject: RE: onKeyPress() > > George, > > See my replies in the body of the e-mail: > > George Walters wrote: > > Rob, and Jonas, in reading your responses there is a concern I have from > > both of your approaches, namely that every time a select_table() is > > performed the entire file has to be read. > > I don't THINK the entire table has to be read on a select_table. I say > THINK because I can't be 100% sure about that. Rob, could you clarify? > > > This wouldn't seem to support any > > substantial software application. The 22 files I've mentioned for an > > 'order > > entry' program represent 20-100Mbytes of data, when you consider 3-5k > > customers, 50k inventory, 2+ stocking locations... etc. Jonas, if this > > is > > happening on your file server just to retreive one record from several > > files, I don't see how it could support multiple users. The server would > > be > > scanning the same files front to end over and over... > > The server does support multiple users. I have been seeing decent > response times in data retrieval and I have in mind a couple of > enhancements to speed up the retrieval process. > > That being stated let me also say that EDS is a simple database. It > certainly cannot (at this point) compete with commercial databases > (SQLServer, Oracle, DB/2, Access, etc.). Not that I want to discourage > you from using EDS/Net but if you're doing a major development as you're > describing you might want to look at other alternatives (you might want > to also look at Matt Lewis' ODBC library in the archive). And I suggest > looking at alternatives for one major reason...EDS does not support > indexes. If you're creating customer and product databases you will > certainly want to provide searches over those databases (my name, > address, product description, etc) and unfortunately EDS just cannot do > that at this time (I have printed database.e and have decided to just do > it myself...if I only had the time). > > If you're still serious about it I can send you privately a VERY simple > order entry app I'm working on. It uses EDS/Net and it will support > multiple users. Just let me know. > > I think you're discovering what I did about Euphoria...you can generate > business apps relatively quickly and be able to support those apps down > the line. And it won't crash your system! > > Good luck. > > Jonas > > > > > > > > > > >