We are having technical difficulties please stand by AGD

[jayloo]

Originally posted by cphilip
Thats partialy the case Jayloo. As I understand it. Maybe easier said than done but yea...

Oh .. sorry if I made it sound simple. What has to be done is the equivalent to open heart surgery. I have been through transitions like this one and it is never pretty.

It seems that there is only one server for these boards....a standby/parallel server to do testing on would be golden at this time.

[darwin]

hey,

if you all want a site to upload on i can set one up.

i have a dual xeon sitting on a nice connection

[InexactMelissa]

Re: Re: Hosting Pictures

Originally posted by jayloo


Contact the vBullitin folks and see hat they say, I am sure this is not the first time this has happened to someone. Or hack the vBullitin code and find a way to spread out the attachments over multiple tables.

Eeeks! That sounds like a nightmare! You'd have to add code to determine the current table size, compare the attachment size to the remaining table size, then if necessary run a make table query and insert that new table into a reference table, and then at last insert the image every time someone wanted to upload something.

It could be that I'm just lazy, but I'd go with the file based attachments if it were me.

[Rich]

vbulletin version 3 has a built in converter to change it from database stored images to file-based storage.

The hardest part is just making sure I have a full backup of the mysql db for automags and then bringing down the boards for the update. The update is the smoothest part, what will take a bit is the conversion from db to files. That process will probably begin early next week.

[TraXeR]

Originally posted by Jack & Coke
Which threads have the most attachments? Just currious...

Most likely 'Official Hot Chick Thread' and 'Official mag pictures'.