• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Query result times in WO and mysql
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.

  • Follow-Ups:
    • Re: Query result times in WO and mysql
      • From: Jake MacMullin <email@hidden>
    • Re: Query result times in WO and mysql
      • From: Arturo PĂ©rez <email@hidden>
  • Prev by Date: Re: Overriding pageWithName
  • Next by Date: Re: Overriding pageWithName
  • Previous by thread: Re: Overriding pageWithName
  • Next by thread: Re: Query result times in WO and mysql
  • Index(es):
    • Date
    • Thread