| Author |
 Topic  |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
 Posted - 04 October 2005 : 08:34:14
|
| Isnīt that what my host tried ruirib ? |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 04 October 2005 : 10:11:13
|
| ruirib, can I send you the details by mail, so you can give it a try? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 04 October 2005 : 14:42:08
|
| Mail sent ! |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 05 October 2005 : 04:33:11
|
I've been pondering this over overnight - it's been getting to me! You're the only user on a SQL Server, and getting miserable response times...I don't get it
One question which did come to mind was what is the server spec? Is it trying to run several websites plus SQL Server at the same time? IIS and SQL Server make poor bedmates as they both want to stretch out into memory, and if there's too little memory in the box, it'll be paging to disk which will slow things down somewhat... |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 05 October 2005 : 04:37:56
|
Well, performance is great, just except the very long topics, and it seems that the more pages a topic the slower the performance, the default.asp pages generates in 0.35 seconds, and so does many of the "normal" topics, but the big ones (over 500 pages or do) generates in 4 or 5 seconds, where Access did it in just above 1 second.
I will ask my host about the server.
Sorry, that I canīt post a link to the forum, itīs a private members only forum, but I can give you the details by mail, if you like. |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 05 October 2005 : 05:53:24
|
nah, no need - I suspect sp_cursoropen is to blame - cursors are the scourge of databasing, and only used for procedural programming against a dataset - it would also explain why it slows down almost linearly with the #recs returned.
If you have query analyser handy, could you enter
sp_helptext 'sp_cursoropen' (and run the query)
We'll see what's in the sproc
The deep root of the problem is that Access (which I believe Snitz was originally written for) does not support stored procedures or proper client-server architecture. When somebody made the adaptation to SQL Server, it still had to work with the Snitz codebase, so had to keep a very similar architecture (and use cursors, etc) - if designed without cursors (to be set-wise, in fact), boy you'd see SQL Server fly compared with Access :)
Let me know what the above test turns up, I'd be interested to see if there are any tunings/easy wins we can put in (without having to rearchitect!) |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 05 October 2005 : 06:14:30
|
| Ok, will try that when I get home. Thanks, I really hope for a solution to this. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 05 October 2005 : 06:39:58
|
Yes, itīs modded, has avatars, active users, polls and private messages.
But the issue here is performance at big topics on SQL, since Access didnīt have this problem.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 October 2005 : 06:42:10
|
I don't know where that stored procedure came from, that's what pdrg was commenting about and being pointed by your host as a proc taking too much time to complete...
I just commented on that. Anything that uses cursors is inherently slower. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 05 October 2005 : 06:54:30
|
| I did make a test on a clean forum (without MODs) on the same SQL database, and it was the same problem, so itīs not the MODs that are causing this. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 October 2005 : 07:14:20
|
| I'm guessing that they didn't really care about the page that was having problems and that is probably the consequence of navigating the members recordset in the members page or similar. Just don't know where the idea about a stored procs script came from. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
Topic Locked
