On 2-04-2002 15:32, "Ulrik Witschass" <[EMAIL PROTECTED]> wrote:
> Also monitor top or the process viewer during the query. I noticed that
> without renicing, MySQLD never jumped over 10% CPU usage. So theoretically,
> I can run 10 queries at the same time and they would be as fast as running
> j
On 2-04-2002 15:28, "Ulrik Witschass" <[EMAIL PROTECTED]> wrote:
> If many other tasks are running, try to renice it (though not too much).
What does renice mean? How can I do that?
> I just ran an INNER JOIN query with a result of 21397 records in the set on
> my 867 G4 and it took around 0.5
I'm doing some benchmarks in order to understand where are the bottlenecks
in my solution and I found that a SQL query on a table with 12000 records
takes 0,87 seconds to preform (Dual 800 G4 MacOS X Server)
0,87 sec may seem fast but it is not on a solution which is going to have a
lot of traffic
