1. 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
>
>
>