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 be
"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 syn
