| Author |
 Topic  |
|
|
impax
Starting Member
7 Posts |
 Posted - 07 May 2002 : 17:40:24
|
Sometimes it does load, but it takes over a minute. All admin functions work and individual forums seem allright (still a little slow i think) I am running this on an SQL server 7/Win 2k adv server, which I Admin. The SQL server also stores my company's online store data in a diff database. Our main website (which must access this same SQL server constantly) is very zippy...
Any ideas?
Our website is:
http://www.anycraze.com
Snitz is installed here:
http://www.anycraze.com/forum
OK, before I posted i triple checked to see that there wasn't another post about this...and I did find a topic with some useful information
one piece said to change the conn string to something like this:
quote:
Provider=SQLOLEDB;Data Source=YourServer;Initial Catalog=YourDB;User ID=YourID;Password=YourPwd;
I did this and it did help, the load time dropped from about a minnute to 8-10 seconds....which is still much slower than the storefront.
My old conn string:
driver={SQL Server};server=10.10.10.2;database=sf2k;uid=<un>;pwd=<pw>
New conn String:
Provider=SQLOLEDB;Data Source=10.10.10.2;Initial Catalog=sf2k;User ID=<un>;Password=<pw>;
Also mentioned was:
quote:
I would make sure your SQL server supports mixed-mode authentication (either Windows or SQL Server logins) and ensure you are using the right network library for the connection to SQL server.
Doesnt giving an ip address for the server= parameter in the conn string ensure that I am using the tcpip library?
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
impax
Starting Member
7 Posts |
Posted - 08 May 2002 : 15:06:39
|
OK, I uncommented the timer code, and it is working.
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 May 2002 : 15:31:59
|
You have another problem; your forum just got hacked. Haven't you looked at the posts here? Download Aaron's version of the Snitz code and setup the forum again.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
nomad_2k
Junior Member
United Kingdom
173 Posts |
|
|
impax
Starting Member
7 Posts |
Posted - 08 May 2002 : 17:14:53
|
HAHAHA....seriously stupid, this must have happend right after i added the time. This forum isn't live yet, so it doesn't really matter. I will re-install the board with Arrons version, maybe i messsed up during install the first time anyway...(I can hope anyway). Thanks for your help.
|
|
|
|
impax
Starting Member
7 Posts |
Posted - 09 May 2002 : 14:44:20
|
Ok, I have re-installed this board using Aaron's version...it seems to still have a performance problem. but oddly now it is when you view a forum. default.asp loads in about 4 seconds (which is acceptable) and forum.asp loads the empty test forum in over 10 seconds... Could this have anything to do with the fact that I created a seperate database for the forum? If so, Should I use the same database for the forum as I am using for the rest of my site? Would this couse any conflicts with my main database?
Conn string and forum link listed in my original post.
|
|
|
|
impax
Starting Member
7 Posts |
Posted - 09 May 2002 : 15:20:21
|
More info:
if I use this conn string:
driver={SQL Server};server=10.10.10.2;database=sf2k;uid=<un>;pwd=<pw>
dafualt.asp loads in 30 seconds and forum.asp loads in under a minute
if I use this conn string: (current)
Provider=SQLOLEDB;Data Source=10.10.10.2;Initial Catalog=sf2k;User ID=<un>;Password=<pw>;
default.asp loads in approx 5 seconds, forum.asp loads in approx 15 seconds.
Im clueless. 
|
|
|
|
impax
Starting Member
7 Posts |
Posted - 09 May 2002 : 15:22:25
|
oops, when i said under a minute...i meant under a second, for the 1st conn string in my last post
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 May 2002 : 16:50:24
|
Hey I've never seen anything this weird. Do you have the latest MDAC installed? If you don't try Microsoft's site (just serach for MDAC...)
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
impax
Starting Member
7 Posts |
Posted - 09 May 2002 : 17:00:50
|
Do you know if it would be a Bad Thing(tm) if i installed the forum taqbles in the same database as my storefront data?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 May 2002 : 17:39:35
|
quote:
Do you know if it would be a Bad Thing(tm) if i installed the forum taqbles in the same database as my storefront data?
No, in principle, I don't think it would be a bad thing. If we were talking about a huge database with performance problems already, probably it wouldn't be advisable. Otherwise I see no major problems with that.
I believe a big number of Snitz users do it.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Cycas
Starting Member
United Kingdom
14 Posts |
Posted - 09 May 2002 : 18:51:02
|
I set up my first forum about a week ago (I'm the only user until it's launched soon) at www.vslondon.org/forum2/default.asp. It works adequately/well, every day, any time before 9pm GMT or after midnight. Between those times it times out. It's running on a windows Server and using an Access DB
I started with Aaron's bug fixed version, installed Davio's Email Random Password Mod, added a single field to the FORUM_MEMBERS table and linked some asp pages of my own (which access the new field using a DSN). My asp pages use a couple of session variables (svPass and svUser svAccess) generated by MFX login (Macromedia Ultradev Extension).
My ISP says that a confuguration conflict is the most likely cause but I don't understand how it could be so time dependent. One minute the response time is fine, next its timing out.
Any ideas?
ps I did the members bug fix and as far as I'm aware I haven't been hacked. Of course I won't know until 1am when it starts working again 
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 May 2002 : 19:01:12
|
Looks like a server issue, I'd say. Your host should be able to provide you with more info on that.
Anyway, what conn string are you using?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Cycas
Starting Member
United Kingdom
14 Posts |
Posted - 10 May 2002 : 06:22:48
|
Thanks for asking Ruirib
This is the connString in config.asp:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=e:\domains\vslondon.org\user\private\f2\snitz_forums_2000_2000.mdb" '## MS Access 97
(The second "2000" is just ot tell me its an Access 2000 version.)
The ISP set up the DSN to the same database for me.
|
|
|
| |
Topic |
|
Topic Locked
