| Author |
 Topic  |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 Posted - 07 October 2005 : 09:36:25
|
I won't email him, but I'll try to put it somewhere he can download it. You're not talking about the Access DB, wii, are you?
wii, I will delete the DB as per your request, no worries  . |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 07 October 2005 : 09:43:47
|
only 100Mb , mmm, I wouldn't expect a db of that size to have too many issues even with very long topics.
quote:
Frankly, I think it may be hard to achieve that. Just the query that retrieves the replies, with all the indexes recommended by the tunning wizard took more than a sec (no cursors in use).
by more than a second, how much more do you mean, 1 second to return >100 pages of replies is actually pretty quick, when you think about how much info is being retrieved. how long does the forum take to display these results ? however it may still be quicker to pull replies into a seperate table before linking them with the members table to extract that info, rather than doing it all in one query, I'm not saying it definately will, but it certainly merits some investigation to see. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 October 2005 : 10:19:12
|
I will send a link to the DB files in a few minutes, Huw. It took about 1.1 secs to retrieve what i think is about 15000 replies (not sure about it now). I agree that it is not much, but Access does it faster  .
As I posted before, in my own computer, it took about 1.2-1.4 secs for the forum to generate the page. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 07 October 2005 : 10:20:49
|
| wii, how long does it take your forum to generate the page ? |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 07 October 2005 : 10:48:11
|
| 4 to 5 seconds on the long topics, everything else is really fast 0.5 - 0.9 or so. |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 10 October 2005 : 05:12:44
|
| Btw, I made a test with a clean install of Snitz (no MODS) on another server, and imported just the tables that are needed to show the topics, forums and posts - and itīs still the same. Short topics load on average 0.5 - long topics 4-5 seconds, even longer sometimes. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 10 October 2005 : 11:08:19
|
| Not sure, show me a server I can use that does this better. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
MarcelG
Retired Support Moderator
Netherlands
2625 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 10 October 2005 : 19:37:17
|
here ya go wii http://xx.xx.xx.xx/forum/topic.asp?TOPIC_ID=1675 for me takes 1.47 secs, jumping to another page takes 2.43 secs
edit - per wii's request, link changed |
Edited by - pdrg on 11 October 2005 04:20:23 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 11 October 2005 : 03:52:41
|
WOW, that sure is fast, but please HuwR, can you remove the link, itīs a private forum.
Thanks |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 11 October 2005 : 04:23:08
|
Thanks a lot pdrg,
That server sure performs well, I will contact my host and tell them how a server should perform - LOL |
|
|
|
Topic |
|
Topic Locked
.