| Author |
 Topic  |
|
|
John Bour
Starting Member
30 Posts |
 Posted - 23 June 2002 : 07:41:01
|
I ask my self upon opening the connection in the global.asa file.
Usually, it make forum faster because you don't have to open connection each time you open a page no ?
Can sb tell me if I'm right ?
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 23 June 2002 : 08:49:08
|
You shouldn't do that. You can maintain the connection string defined in a session variable, but you should not do that with the conenction itself. ADO is designed to "reuse" connections, so to say, so the recommended thing to do is open the connection when you need it and close it immediately when you stop needing it. Doing otherwise may severely limit the number of users you can have simultaneously, since it would more rapidly contribute to an exhaustion of resources on the server.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
John Bour
Starting Member
30 Posts |
Posted - 23 June 2002 : 11:12:09
|
OK.
But why the forum seem so slow...
I tried the Webwizguide one too (in the same server) which seem faster. It is due to junction between tables which are more optimized ?
But so far, I'll use the Snitz one because of the module andcontibute to develop it a bit (with ASPUpload forms for examples).
In fact I want to change the one I use (ABB from Bheller.com) because I don't want to rewrite it for SQL ;)
Edited by - John Bour on 23 June 2002 14:23:32 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
John Bour
Starting Member
30 Posts |
Posted - 23 June 2002 : 13:45:29
|
SQL 2000 like :
strConnString = "driver={SQL Server};server=IPServer;uid=myuid;pwd=mypwd;database=databasename" '## MS SQL Server 2000
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 23 June 2002 : 14:04:42
|
quote:
SQL 2000 like :
strConnString = "driver={SQL Server};server=IPServer;uid=myuid;pwd=mypwd;database=databasename" '## MS SQL Server 2000
Try changing it to:
strConnString = "Provider=SQLOLEDB;Data Source=IPServer;Initial Catalog=databasename;User ID=myuid;Password=mypwd;"
This OLEDB driver is much faster. I've seen some dramatic reductions in page loading time just by changing to it. Let me know if you find the forum still slow after changing this.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
John Bour
Starting Member
30 Posts |
Posted - 23 June 2002 : 14:25:23
|
Thanks
It seem to be better ;)
So I could began implementation in a faster server (this one is an old Bipro 300)
A last question, where can I see developpement in progress about the v4b3?
I don't want to rewrite sth written ;)
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 23 June 2002 : 16:04:56
|
Basically version 4.0 will only move forward after 3.4's release. There will be, I believe, a v4.Beta04 that will basically be v.3.4 with some features for easing up translation, just like what happens now with 3.3 vs. 4.0beta03 and after that is completed, v4.0 will be the next goal.
Regarding 3.4 features I'd suggest a search on 3.4, using the quick search page: http://forum.snitz.com:1432/start. I think you'll find a lot about that.
Anyway I would probaby suggest that you post what you plan to do here, since it is possible that someone else has already done something similar, or has some ideas on the specific functionality that you want to adress.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
John Bour
Starting Member
30 Posts |
Posted - 24 June 2002 : 02:54:27
|
Ok, I'll do it before writting sth
Thanks again
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
.