Laston Table is huge, can i empty it?

[rcsmith]

in mysqladmin my laston table has 259,000 entries. Can this be emptied? my photopost has been ruining my server lately. I'm up to 15,000 images. I just need to find a way to optimize mysql usage.

[Chuck S]

You can empty it safely. Other ones as iponline ipcache admlog can be emptied as well

[rcsmith]

thanks for the info. My main page seems to load a lot faster now. My site always has over 100+ guests online at once looking at pictures. A good day will be around 180.

Have you thought of doing more sql optimaztion. I'm not a pro, but I ran into this problem with OScommerce and 12,000 products. All the products are just in one table, products. I see in photopost all the images are in the table photos.

If it were broken up into more tables say like photo-a photo-b etc would that speed things up for sites with thousands of images?

[Chuck S]

Our problem has been optimized alot. 5.2 even has a cache table that loads the index and popular items from a cache and not the tables.

[rcsmith]

i have my options set for yes, but if I look at the source on my page there is this. Would that cancel it out?

<!-- no cache headers -->
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="expires" content="Tue, 21 Nov 2000 05:00:00 GMT" />
<meta http-equiv="cache-control" content="no-cache, must-revalidate" />
<!-- end no cache headers -->

[Chuck S]

That has nothing to do with our cache thats our normal headers

The cache grabs the cat info etc from the cache table instead of multiple queries and tables which saves generation time and over half the needed queries to generate the page. Thats how it works