| Author |
 Topic  |
|
|
danielwym
Starting Member
Hong Kong
16 Posts |
 Posted - 07 June 2004 : 00:14:28
|
Hi all,
My MSSQL server spec is PIII 750, 1G RAM and snitz in another web server with same config. Recently, i trace the Current activity in "enterprise manager", there is serveral blocking process that make the forum non-function.
In post_info.asp, there is many "insert ID....." and then "select Max(ID)...." at once and finally update the count / views. Will this cause the blocking happen? or will i use @@identity better? Any hints? Thanks for the great help. |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 07 June 2004 : 04:46:29
|
no this should not cause any blocking.
Do you have any mods installed ?
How did you create your SQL db, did you create it using the forum setup or did you upsize an access db |
 |
|
|
danielwym
Starting Member
Hong Kong
16 Posts |
Posted - 07 June 2004 : 05:09:20
|
Hi HuwR,
Thanks for reply. I have also installed post sort MOD, site integration & anonymous post MOD in the snitz webserver.
Sorry.. ....Forum setup means...? Just wonder the case if the users insert posts then select the same ID to update...
Thanks and looking forward to your reply.
Cheers |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 07 June 2004 : 05:46:36
|
quote:
Originally posted by danielwym
Sorry.. ....Forum setup means...? Just wonder the case if the users insert posts then select the same ID to update...
Did you use Snitz to create your SQL tables, or have you migrated it from a previous access database.
Under normal circumstances the forum should not lock anything which would cause your forum not to function, even if it is extremely busy.
Can you work out which tables are being locked, enterprise manager should tell you the query which is locking the process, once you know this I can advise you haow to prevent it, most likely it needs a clustered index creating on something. |
|
|
|
danielwym
Starting Member
Hong Kong
16 Posts |
Posted - 09 June 2004 : 00:36:52
|
First installation it is. And just generate the SQL scripts with indexing to the new database later.
Mostly likely, they are the queries for FORUM_TOPICS & FORUM_REPLY.......
|
|
|
| |
Topic |
|
Topic Locked
