Previous Thread
Next Thread
Print Thread
Hop To
#208728 03/18/2008 1:58 PM
Joined: Mar 2008
Posts: 1
2
stranger
stranger
2 Offline
Joined: Mar 2008
Posts: 1
I am having wierd behacvior on 6.5.2. - I run a huge fishing forum 13 thousand users and all posts which have any kind of photo attached just hang and take up to 30 to 60 seconds to load.

This happens in one forum but not all.

I have 26 thousand user uploaded pics - about 7 gigs of data

When people try and pull up threads they just hang - the sql server is not overloaded nor is the server.

I have tried optimizing all my tables etc... but alas nothing is working.

Does anyone have an sql command which would delete all attached photos over a time range? My forum is 4 years old now and I would delete photos older than a certain agae.

Any help would be appreciated.

Thanks

J -


Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
You may need to open a support ticket, I think I've updated all 6.5series forums to 7.something by now. You might consider updating as well, I don't think people are having issues with attachments now.


- Allen
- ThreadsDev | PraiseCafe
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
I found a site still running 6.5.5 - I don't think there's a time attached to attachments, except for the posts' time. You could delete the older topics that have attachments, but you run the risk of corrupting your Posts table.


- Allen
- ThreadsDev | PraiseCafe

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Ruben), 476 guests, and 111 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)