Query result times in WO and mysql
Query result times in WO and mysql
- Subject: Query result times in WO and mysql
- From: Klaus Berkling <email@hidden>
- Date: Tue, 20 Jan 2004 15:02:32 -0800
I am in the middle of a large project porting an old file based system
to WebObjects/MySQL. I am also somewhat new to WebObjects.
It takes about 2 seconds to run a query against MySQL using
EOUtilities.rawRowsForSQL().
It takes about 0.26 seconds for the same query in the mysql command
line utility.
There is about 346KB of data in 5500 rows.
Is this normal?
WebObjects 5.2
MySQL 4.0.15
MySQL-ConnectorJ-3.0.6.jar
Dual 1Ghz/1MB RAM
(I'm using rawRowsForSQL because I use LIMITs, not using raw SQL makes
things much slower.)
Thanks for any insights.
kib
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.