Re: Slow queries with very large table

[Enrique Rochina]

Hello Rick,

Thanks for your response.

After seeing how your laptop performs with a few million rows table, I realise how bad our database performs, specially because our hard disk is 16k rpm!

Unfortunately, making count(*) instead of count(pk) is not an option, as the query is made by the e-commerce solution.

After your suggestions, we expect to make on this table
- dropping unused indexes
- splitting the database file into one per table (maintenance purposes)
- removing an ordered option that is declared in our e-commerce solution setup. The support said that slows down performance on that tables, but I don't see the relation for this specific query. Anyway it won't hurt

Many thanks && best regards,
Enrique