From: Brian Le Roy <brian@...>
Date: 2005-09-09T05:48:42+09:00
Subject: Re: general performance question

no, but the table has 140K records.  the disk isn't crunching, so the 
index should be okay.  i was thinking it would be passing around the 
database connection object causing overhead.  i took the result set 
object and created a straight ol' array for passing.  no improvement - 
so maybe there's nothing to do.  thanks for all the responses - i'll 
keep messing with it and if i find something that improves it, i'll let 
you know!

bonefry wrote:
> Well, that's it.
> 
> MySql can take even 100% of your processing power. It happenes when you
> have complex queries to run, and you run them on big tables. Are you
> running complex queries ?
> 
> 
>