Hey all. I'm anxiously awaiting the Gold release of 3.5. I haven't purchased yet, but as soon as its out (I just don't see the sense of ordering sooner just to play with beta/rc).
In any case, my current host is Powweb. I am pleased with them for such an affordable solution (I don't run a large board, at least compared to most of you guys). Here's my issue:
Powweb limits the number of queries to 72,000 per hour. I have roughly 3000 accounts (only about 200 active per day) and around 65000 posts. I already know that converting over in just one step will choke the max_questions limit. With the program ImpEX, is it set up so that you can run it in batches, as to limit the number of queries to the database per hour so I don't step over the max_questions limit?
If not, would this solution be possible: Powweb limits each MySQL user to 72,000 queries per hour. BUT they allow you 3 MySQL login/accounts. So combined that's 3 * 72,000. Is there a way to utilize this? Either a way to make a script that passes a token to the next account after a query, OR a way to randomize the selection of account to log in, thus utilizing the 3 accounts to run the converter?
I guess this leads me to another thought. For those users that run a board with a low max_questions limit, could such a script be created to utilize multiple accounts to run a board? (This probably should be directed at vb.org)
In any case, I'm not so much worried about the board going over it's max_questions limit when it's running, but I am worried about it when I try to convert over from phpBB 2.0.17 to vBulletin 3.5 gold.
I sure hope this post makes sense.
Take it easy
KidneyBoy
In any case, my current host is Powweb. I am pleased with them for such an affordable solution (I don't run a large board, at least compared to most of you guys). Here's my issue:
Powweb limits the number of queries to 72,000 per hour. I have roughly 3000 accounts (only about 200 active per day) and around 65000 posts. I already know that converting over in just one step will choke the max_questions limit. With the program ImpEX, is it set up so that you can run it in batches, as to limit the number of queries to the database per hour so I don't step over the max_questions limit?
If not, would this solution be possible: Powweb limits each MySQL user to 72,000 queries per hour. BUT they allow you 3 MySQL login/accounts. So combined that's 3 * 72,000. Is there a way to utilize this? Either a way to make a script that passes a token to the next account after a query, OR a way to randomize the selection of account to log in, thus utilizing the 3 accounts to run the converter?
I guess this leads me to another thought. For those users that run a board with a low max_questions limit, could such a script be created to utilize multiple accounts to run a board? (This probably should be directed at vb.org)
In any case, I'm not so much worried about the board going over it's max_questions limit when it's running, but I am worried about it when I try to convert over from phpBB 2.0.17 to vBulletin 3.5 gold.
I sure hope this post makes sense.
Take it easy
KidneyBoy
Comment