That's amazing that the round trip from Australia to Europe is so fast!
The particular table I am referring to has around 120,000 entries and each row
has about 650 bytes.
I guess I'll try testing without using the data control and connect at app.open
as you do.
Thanks!
Will
----- Original Message -----
From: POIDINGER, Michael [JJRAU]
To: 'Getting Started'
Sent: Sunday, January 30, 2005 7:14 PM
Subject: RE: MySQL and MySQL plugin performance
> -----Original Message-----
> From: gettingstarted-bounces at lists dot realsoftware dot com
> [mailto:gettingstarted-bounces at lists dot realsoftware dot com] On
> Behalf Of Will Brokenbourgh
> Sent: Monday, January 31, 2005 1:55 PM
> To: Getting Started
> Subject: Re: MySQL and MySQL plugin performance
>
> I'm not at all insulted, just happy to get some advice.
>
> Yes, the fields selected were indexed, for example
> 'LastName', 'FirstName', 'SystemID', etc. I even optimized
> the database beforehand, just to make sure everything was okay.
>
> Regarding remote and local, I tried both. The times I
> originally posted were for local. For remote (100 megabit
> through switch) it was about 1 second longer in each case.
>
It's odd. I connect from Australia to a MySQL database in Europe, and for
the query
"select * from table where id < 10"
it takes 400 millisecs. table has 52000 entries
I don't have a similar query on my local systems, but it does take 6 secs to
retrieve 10000 records and instantiate each one as an object
I have not optimixed any tables nor done anything special with the plugin
(they are all indexed though)
I never use datacontrols, but I am wondering if your system has to reconnect
to the DB everytime it does something? I always use a persistent
MysqlDatabase object connected at app.open attached as an attribute to app.
It might be your lag is due to object creation/garbage collection
I also find my "local" remote db fater than localhost. Dunno why.
Mike
_______________________________________________
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>
_______________________________________________
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>
|