Subject Re: commit after insert is very slow
Author svanderclock
> So, the resultset itself can be large, but you only need a few rows? Do you
> ever need
> such large resultsets?

we need only the first 200 row, but ordered :(

> When an index is used, the engine returns the first few rows quickly, but
> pulling the
> entire resultset will probably take more time than without an index.

exactly, but as we never need more than 200 rows it's ok