On 4 Oct 99, at 10:26, almir kazazic wrote:
> i have tham too , but i still had no results dont know why, also i am using
> myadmin and mysql but i would like to know if this statment fast is on a
> huge DB or not or how can i make it better
>
Didn't you have any results of the benchmark run? Did you take a
look in the output dir?
or don't you how to test a statement and to see how fast it is and
how to get the query faster?
If you have a query you can run the querie in mysql and see the
result with some timing under it. You could also tests the speed of
some function with the benchmark function (see manual how to do
that) if you would like to optimise your query just type EXPLAIN
before your query and execute it again to see how your query is
done internally. See the manual for an explenation of the output.
Greetz...
Luuk
