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!
My questions are:
* Is there something I can do to increase RB's MySQL performance (besides the
obvious things like RAM, faster machine, correct column indexing)?
* If not, are there plans to fix this soon?
Because of some complexities, I'd rather stay away from the ODBC plugin.
Thanks!
Will
_______________________________________________
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>
|