🚀 go-pugleaf

In article <6hg47g$jb78@forums.borland.com>, richards@swmed.edu says...
> Gerald,
> 
> All fingers point to the BDE. It just cannot do SQL joins on _dbf_ tables
> efficiently. If you can, try linking your dbfs in Access97 and do the same
> join - it works instantly.
> 
> Hello BDE development team???
> 
> Charles Richards
> 
> 
> Gerald Fay wrote in message ...
> >I've mentioned this on the vdb programing newsgroup, but it is more
> >appropriate to discuss this here. No development can occur in VdB until
> >one has a relative feeling for the speed of data processing. I want to do
> >this development right the first time.
> >
> >The new VdB 7 changes all the rules.
> >
> >From my own experimenting I have found SQL to be much faster than just
> >using filters, on an individual dbf. On Joins the feeling is the
> >opposite. A simple join (outer right) on two databases with about 30,000
> >entries, filtered ("where" in SQL) for a specific field (not the joined
> >field) takes about 2 minutes. While the outer right join is useful to
> >work on live data, would it be faster to do this any other SQL way?
> >
> >Just for speed comparison, using tradition DBF style rowset.findkey()
> >with the index ordered on the "filter" field then doing a lookup from the
> >"join key" (not actually joining) onto the second dbf and storing the
> >data to an array takes only 5 seconds. (40x's faster than sql)
> >
> >Is this what one should expect?
> >
> >Any pointers appreciated.
> >
> >Thanks.
> >
> >
> >--
> >Gerald Fay
> >gjfay@msn.com
> 
> 
> 
Not instantly,

It took 3 seconds (and returned 680 results). Sure beats >1.5 minute OUCH 
pretty painful. I really have gotten to like the designer interface with 
VdB7, but these query results are pretty bad. I may have to hold off on 
my development plans.

Looks like the BDE needs some work.


-- 
Gerald Fay
gjfay@msn.com