Thanks for your reply. I would say that about 80 000 object has frontpageimage=0, but we are only interested in the last published object, thats why we use limit, 1.
This is a news site. The content objects are already placed in the folders where they should be, we cant use a deeper hierarchy. And the number of content objects grows with about 6000 per day... Also, we dont want to move older objects to some kind of archive folder, as they will then lose the url:s indexed in search engines.
The way MySQL handles the queries is really slowing down our results due to the huge amount of data in the database.
We are now trying to create our own operator for these kind of fetches, hopefully this will be faster.
Best regards, /Nicklas
Nicklas Lundgren, Managing Director
Novitell AB, Sweden