| Author |
 Topic  |
|
|
sr_erick
Senior Member
USA
1318 Posts |
 Posted - 22 June 2004 : 09:53:42
|
A couple of questions with updating forum counts, etc.. Ok, here's the deal, we have FORUM_TOTALS as a table which stores post count, topic count, user count, topic archive count and post archive count. Where are the totals for topics count and post count for each seperate forum held? Also, how does "Update Forum Counts" in the admin section work, what does it all do? It always times out for me, does it loop through to count or does it do a SELECT COUNT (*) FROM ... Or maybe I'm just too used to MSSQL and access and MySQL can't do this.
Also, could someone sort of explain how the archiving script does in order as I want to create a stored procedure to do this for me and schedule it. Is this right?
-Move topic to FORUM_A_TOPICS
-Move all posts for topic to FORUM_A REPLY
-Update all topic counts and totals
-Go to next topic
Thanks! |
Erick
Snowmobile Fanatics
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 June 2004 : 11:03:07
|
Totals for each forum are stored in the FORUM_FORUM table.
Update forum counts actually performs all the counts for each item that needs to be counted. I see no reason for MySQL to fail on those counts.
Jeepaholic has created a script for MS SQL to do topics archiving. It's in the MS SQL forum I believe. Do a search. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 22 June 2004 : 12:01:14
|
So you don't think the update forum counts should fail? I don't see why it would either, but it does time out.
As for the archiving, I will search for it, and probably convert it to sproc to run as a job daily. |
Erick
Snowmobile Fanatics
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 June 2004 : 12:11:15
|
| I've seen it fail, and with MS SQL just changing provider would fix it. You could probably check the indexes and add indexes as needed, if needed. I can't help much since I don't know the MySQL DB structure. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 22 June 2004 : 12:41:55
|
I'm not using MySQL, I use MSSQL. I don't think I'd use MySQL if you paid me.  |
Erick
Snowmobile Fanatics
|
|
|
| |
Topic |
|
Topic Locked
