| Author |
 Topic  |
|
|
Machina
New Member
Switzerland
74 Posts |
 Posted - 11 February 2005 : 05:44:46
|
Hello everybody 
I have a recurrent problem on my snitz forum. Sometime someone will get a time out when he sends the reply in a topic.
But, the reply is written in the database.
The problem, is : when this happens in a topic, this topic becomes very very very long to access to.
Do you have any idea about the origin of such a problem? I asked my administrators to verify the sql server, the proxy, but they don't know...  |
Machina
-------
http://www.jaboulay.fr
--------
Snitz based site:
http://www.itu.int/YLinICTs
MODS Used : TMPJ's Header Cell Image, Site Integration, Front Page News, News Events Calendar, Nikkol's Usergroups, Simple Slash, Avatar, File Sharing, Links |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Machina
New Member
Switzerland
74 Posts |
Posted - 11 February 2005 : 06:18:21
|
| No, I don't use subscription |
Machina
-------
http://www.jaboulay.fr
--------
Snitz based site:
http://www.itu.int/YLinICTs
MODS Used : TMPJ's Header Cell Image, Site Integration, Front Page News, News Events Calendar, Nikkol's Usergroups, Simple Slash, Avatar, File Sharing, Links |
 |
|
|
Machina
New Member
Switzerland
74 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 11 February 2005 : 10:27:13
|
quote:
Originally posted by Machina
For example, this page http://www.itu.int/ITU-D/youth/YLinICTs/topic.asp?TOPIC_ID=578
took 36 seconds to be generated 
Did you create your SQL tables using the forums setup.asp ? or did you migrate from Access to SQL, if so you may not have any indexes.
If yo did use the forums setup to create your tables, then it your server is either underpowered or extremely overloaded |
|
|
|
Machina
New Member
Switzerland
74 Posts |
Posted - 11 February 2005 : 11:13:47
|
It is not a migration from Access. I created it directly in SQL server with Snitz setup and indexes are here.
When I get the problem, the Reply record is created but the corresponding Topic is not updated.
Maybe should I ask again my administrator  |
Machina
-------
http://www.jaboulay.fr
--------
Snitz based site:
http://www.itu.int/YLinICTs
MODS Used : TMPJ's Header Cell Image, Site Integration, Front Page News, News Events Calendar, Nikkol's Usergroups, Simple Slash, Avatar, File Sharing, Links |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 February 2005 : 12:38:30
|
| I would say the issue may lie with your server, indeed. Anyway, have you compared the database record of such a reply and a "normal" one? Any meaninful difference? What about the topic? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Machina
New Member
Switzerland
74 Posts |
Posted - 14 February 2005 : 04:33:41
|
I looked at the records, and I noticed that the information was correct for the reply records, but the topic record was not updated at all. As if it didn't get the write authorization for this specific record. What is interesting is that even if I manually corrected the information of the Topic so that it is updated, this topic continued to make problems for the following replies. The reply records are normal.
I will inquire more deeply when this problem occurs again.
Bizarre |
Machina
-------
http://www.jaboulay.fr
--------
Snitz based site:
http://www.itu.int/YLinICTs
MODS Used : TMPJ's Header Cell Image, Site Integration, Front Page News, News Events Calendar, Nikkol's Usergroups, Simple Slash, Avatar, File Sharing, Links |
|
|
|
Machina
New Member
Switzerland
74 Posts |
Posted - 21 February 2005 : 09:53:48
|
Problem solved  Partially
I changed the NTEXT fields in TEXT type. I knew there was an issue with ntext but I only dared today to make this change.
It works really better now |
Machina
-------
http://www.jaboulay.fr
--------
Snitz based site:
http://www.itu.int/YLinICTs
MODS Used : TMPJ's Header Cell Image, Site Integration, Front Page News, News Events Calendar, Nikkol's Usergroups, Simple Slash, Avatar, File Sharing, Links |
Edited by - Machina on 22 February 2005 05:56:33 |
|
|
|
Machina
New Member
Switzerland
74 Posts |
Posted - 22 February 2005 : 05:57:47
|
| Changing the type NTEXT to TEXT solved the problem to all the replies and topics that were getting stuck during 30 seconds when you read them. Now the bug is still there and can still create this problem. So it is not the NTEXT type that makes the problem... |
Machina
-------
http://www.jaboulay.fr
--------
Snitz based site:
http://www.itu.int/YLinICTs
MODS Used : TMPJ's Header Cell Image, Site Integration, Front Page News, News Events Calendar, Nikkol's Usergroups, Simple Slash, Avatar, File Sharing, Links |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 February 2005 : 08:29:37
|
That conclusion seems obvious to me. It's not a data type of a column that can cause such a situation. It may be a indexing issue, maybe the column type change made the database remake the index on the table.
Try rebuilding the database indexes running this in Query Analizer:
sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?')"
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 22 February 2005 08:31:05 |
|
|
|
Machina
New Member
Switzerland
74 Posts |
Posted - 22 February 2005 : 09:04:45
|
Thanks,
I ran this query. No error. It didn't solve the problem, the only topic still with this problem is still taking 35 seconds to be displayed.
I pray for the fast death of the current server so that we replace it |
Machina
-------
http://www.jaboulay.fr
--------
Snitz based site:
http://www.itu.int/YLinICTs
MODS Used : TMPJ's Header Cell Image, Site Integration, Front Page News, News Events Calendar, Nikkol's Usergroups, Simple Slash, Avatar, File Sharing, Links |
|
|
| |
Topic |
|
|
|
Topic Locked
