Re: optimizing the query.

[Toa Sty]

Unless you're doing extremely high volumes of inserts adding a few indexes won't hurt you too much and will allow you to query the table orders of magnitude more quickly.

Without indexes you're always gonna perform a full table scan, and that's always gonna take a long time on a large table.

So add some indexes and let us know how you get on :)