I have over 177000 entries in the Wordbook module and I turned Cache on to 3 Days so as to have the pages load faster. This doesn’t happen. Every time I access the index page of Wordbook it takes a long time to load. I’m not too sure how the cache works but is it supposed to store the information that was accessed in templace_c directory, then when someone calls the same page it just loads that instead of querying the database?

comegona:

Wow! That's certainly a lot of entries. I never thought the sheer size of the content could be troublesome, but now that you mention this, I suppose the problem comes not from the module itself but from the fact that the module's index page includes three blocks: latest, most popular and random entries. My guess would be that the module goes over all entries when determining latest and most popular...

From this, I guess I need to reasess the display strategy. An idea might be to have separate tables to hold the id numbers of the latest and the most popular entries, so the module doesn't go over all the entries... I'll have to think about it.

Thanks for the feedback. It's good to know that even in its present state, the module has proven useful.

Cheers.

EDIT: Just visited your site. It takes forever to refresh the pages. The module will need to be completely rebuilt, hopefully with the help of some database wizard.

I had a quick look at the sql queries and my suggestion would be to change the way you check for $totalwords. Do a SELECT count(*) from the table, instead of reading in all the entries. As far as I can see you don't use the $words variable for anything else, though it was just a quick look, like I said, so correct me if I'm wrong :)

Anyway, just a suggestion and I hope it helps...

Rowd

rowdie:

Thanks for the suggestion. As you'll probably see in my code, I was worried about making it work and certainly used no tactics or strategy to build efficient queries. As I learn more about how to do things, I'll build more efficient modules, but hey, it might take long... :)

Cheers.