|
|
Posted by The Natural Philosopher on 01/24/08 15:18
Toby A Inkster wrote:
> The Natural Philosopher wrote:
>
>> Then index everything..
>
> If you index *everything* then you slow down INSERTs.
Well you know what I meant. Everything relevant to the search, but a
classified is a classic instance of post one, read many, type
applications. So a small hit in posting is no biug deal.
> It's better to index
> only the columns that you know will benefit from it. (If you find that you
> need more indexes, it's easy enough to add them later.)
>
Oh yes. The beauty of databases.
We had an old informix systyem once we were developing management
reports for. The first report took 11 hours to complete. The second,
rewritten in syntax to do the correct bits FIRST, took 15 minutes.
Adding indices got it down to around 15 seconds IIRC.
Navigation:
[Reply to this message]
|