>
> I'm porting a pretty large medical accounting app to Windows
> using VB 6 and MS Access. I had an opportunity to evaluate
> RB 5.5.4 and I am very impressed...so impressed that after I
> release this final VB build to our clients, I want to port
> everything to RB.
>
> Obviously, with RB, I will no longer be using Access, so I
> have researched a few different cross-platform DBs. MySQL
> seems to be a good balance of everything my app needs and the
> price is right. I converted the Access DB to MySQL and
> tested RB's MySQL performance with the MySQL plugin and found
> that, on the same machine, RB takes around 3 seconds to
> select a single row in a large table and MS Access through VB
> performs the same query in about 700 milliseconds. Also,
> using the data control, if I move to the previous record in
> RB, it takes about 2.5 seconds, in VB/Access it's
> instantaneous. Quite a difference!
>
No insult intended at the simpleness of this question, but have you indexed
the fields you select on?
Is your database remote or local, and was it remote or local when using
access?
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://www.realsoftware.com/listarchives/lists.html>
|