Hi there,
i´m actually developing a performance criticial system where I need to
index a huge amount of protocoll data.
These data are already in a chronological order, so if I push the data
one by one in the database I will never need an ORDER BY syntax, `cause
mysql already stores the data the
Michael Schoen [EMAIL PROTECTED] wrote:
i?m actually developing a performance criticial system where I need to
index a huge amount of protocoll data.
These data are already in a chronological order, so if I push the data
one by one in the database I will never need an ORDER BY syntax,
I assume you have your ORDER BY field indexed, but your query may not
permit the index to be used for sorting. If you are selecting most of
the data set or very large portions of it, you may try using HAVING
instead of WHERE for you filter. Then the index can be used for the
sort. MySQL will
