| Author |
 Topic  |
|
|
AndyF
Starting Member
6 Posts |
 Posted - 28 August 2002 : 14:49:35
|
I've replaced an existing forum, which hadn't been active for close to a year, with version 3.401 with an access 2000 database (strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\InetPub\forum\db\slc_forum.mdb" '## MS Access 2000).
The database upgraded okay, the forums, catagories, and users all seem to be added correctly. The problem is it is taking between 15 and 60 seconds per page load. Is there something very basic that I missed in setting the forum up that could account for such slow performance?
Andy |
Andy Ferguson |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
AndyF
Starting Member
6 Posts |
Posted - 28 August 2002 : 14:53:22
|
| the Araneae program mentioned in the readme. It could be a host problem, but how can I determine? |
Andy Ferguson |
 |
|
|
taropatch
Average Member
USA
741 Posts |
Posted - 28 August 2002 : 15:13:32
|
I'm still testing 3.4.01 too. At times it seems slower than 3.3.05 which I know should not be the case. The noticeable problem for me is that it seems to occassionally take a long time from post to confirmation page. At worst, it will take over a minute to post. I don't think this happens with the 3.3.05. I'm still watching and playing with it though. I think it may be my host.
I have an Access 2000 db and my host is readyhosting.
AKW |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 28 August 2002 : 16:30:10
|
quote:
Originally posted by taropatch
I'm still testing 3.4.01 too. At times it seems slower than 3.3.05 which I know should not be the case. The noticeable problem for me is that it seems to occassionally take a long time from post to confirmation page. At worst, it will take over a minute to post. I don't think this happens with the 3.3.05. I'm still watching and playing with it though. I think it may be my host.
I have an Access 2000 db and my host is readyhosting.
AKW
This symptom is usually a problem with resources for the database connection or an overworked database. Inserts are slower in general than selects, and the slowness is magnified if your server is "stressed". If you're not using the OLEDB connection string, you should. Otherwise slowness when busy is just a fact of how the Access drivers work and are shared on a web server.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 28 August 2002 : 17:54:40
|
| Just an FYI, my host is readyhosting and they switched me to Medium Pooled to speed up my forum. This is a brand new install with very few posts and page generation time was taking around 2 secs (which is large for a small board). This helped for a while, but now I'm getting page generation times of > 2 sec which appears to be longer because either their pipe out is clogged or my pipe in is.... maybe ReadyHosting has bigger problems right now. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
bax
Junior Member
141 Posts |
Posted - 28 August 2002 : 20:43:15
|
| I don't know much about readyhosting, but do they offer SQL Server? If so, it really might be worth considering. I also know a couple ISPs that offer SQL + web hosting for about $60 a month, if you're interested. I think it would definitely help your performance. |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 28 August 2002 : 21:13:21
|
| ReadyHosting offers SQL for $25/mo extra (I think). And I think the slowness that I'm experiencing now is partly host but mostly my cruddy connection. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
bax
Junior Member
141 Posts |
Posted - 28 August 2002 : 23:12:03
|
| Yes, connection is always an issue. There's a good page that can give you info about your connection speed - www.cyscape.com/showbrow.asp - find the Connection Speed. I've found it to be reasonably accurate. Anything above 15 k/s is OK. Obviously, the higher the better. |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
bax
Junior Member
141 Posts |
Posted - 28 August 2002 : 23:19:22
|
That's probably your answer. I'd ask some people with fast connections to check out your forum and see how fast it goes for them.
To the original poster, what tpye of connection do you have? |
|
|
|
taropatch
Average Member
USA
741 Posts |
Posted - 28 August 2002 : 23:44:48
|
86580 bits/sec (10.57 KBytes/sec)
Thanks for the link.
Any slowness must be my host, because I was playing around with my 3.4.01 test site tonight, and it seemed fine (fast). My concern was when it seemed slow from my work where I have a fast connection (~3000 KBytes/sec).
AKW |
Edited by - taropatch on 28 August 2002 23:47:03 |
|
|
|
bax
Junior Member
141 Posts |
Posted - 28 August 2002 : 23:58:36
|
| Taropatch. You in Hawaii by any chance? |
|
|
|
taropatch
Average Member
USA
741 Posts |
Posted - 29 August 2002 : 10:15:12
|
Bax,
I wish I were in Hawai`i right now. To many people's surprise, I am in NJ, but my site is dedicated to Hawaiian slack key guitar.
Aloha,
AKW |
|
|
|
DJRobX
Starting Member
USA
11 Posts |
Posted - 16 September 2002 : 05:25:01
|
quote:
I don't know much about readyhosting, but do they offer SQL Server? If so, it really might be worth considering.
Do not bother with a SQL database on Readyhosting. At first it worked fine. Then, at some point last year, Readyhosting got hacked. When that happened, they installed the Checkpoint firewall software. However they configured it, all of the "internal" SQL traffic went through the firewall, slowing forums to a crawl (usually couldn't make it through displaying a page). After a couple months of them doing nothing to fix it, they finally did something and the forums worked again. It ran, but still unacceptably slow. The forums never were able to work like they did prior to the disaster, and their support wouldn't do anything about it. |
|
|
| |
Topic |
|
Topic Locked
