[Zachariah]

Originally Posted by ConqSoft

But PhotoPost vBGallery is integrated with vBulletin, and uses all vBulletin connection info. No separate configuration.

Here was some thoughts from: Freddie Bingham @ vb.com

Originally Posted by Zachariah

This may be a vb.org hack, but I am sure others may have ran into this issue.

I have ran into webhosts that because of "hackers and server loads" have a cap on questions mySQL server can be given in a time frame. ( I do not know the time frame)

"Error: SQL server exceeded 50,000 max questions" --- All mySQL is stoped for like 5 min then all is ok. The server it self auto temp bans then mysql account.

I was thinking of a script / VB Scheduled Task that would do steps like "Rebuild Search Index" to do like 10,000 questions a day/hour/whatever or some set value untill done. Is there a way to start and index, "pause" and contenue later ? - There may be many other "index" type operations that need this "if it can be done"

Most if not all of the Maintenance => Update Counters tasks.

Originally Posted by Freddie Bingham

One workaround is to create multiple mysql users in your hosting account. In config.php you randomly pick one of these users to connect to the database. This will spread the questions between users and since the limit is per user, you can usually overcome the problem.