| Author |
 Topic  |
|
|
flux
Starting Member
46 Posts |
 Posted - 17 June 2001 : 15:42:31
|
the community i tried to start is growing and growing. At first the page load was quite fast, but now as the post and members increase, I was wondering if it would be safer to switch from access to sql.
The reason for me wanting to do this is that quite a few of my members have complained about being timed out and not being able to get to the forum itself. Is this a server problem or is it the code?
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 17 June 2001 : 16:29:52
|
this question has come up quite a lot and I can tell you that I transferred a forum with many, many mods and a user base of 300 over to SQL7 in about 5 minutes. If you have MS MSL7 they have an import utility that is so easy to use. Then all you have to do is use the SQL connection string in the config.sys.
If you can afford this path I would suggest doing it.
Dayve |
 |
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 18 June 2001 : 00:51:02
|
Question: Can you just as easily go backwards from SQL to Access? Is this possible?
__________________________________
Snowmobile Fanatics
|
|
|
|
RedZone
Starting Member
USA
23 Posts |
Posted - 18 June 2001 : 01:29:43
|
Yes, SQL Server 2k (what I am running) has the ability to export your data to an Access DB - Provide the Access DB filename along with username/password and it'll dump the data.
--RedZone
|
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 18 June 2001 : 04:59:44
|
would it be feasible in snitz to have the forum being run on an SQL2k db, and the archive be in a access db, still giving the members the ability to view the archived messages? Has anyone done this?
<-- Eric -->
InsideWaco.com |
|
|
|
Freeman II
Junior Member
232 Posts |
Posted - 21 July 2001 : 15:01:44
|
i wanna know the answer too
what are the advantages of Sql over access?
|
|
|
|
stuF
Average Member
United Kingdom
561 Posts |
Posted - 21 July 2001 : 15:19:14
|
if it is your server script timing out, add this to the top of inc_top.asp before anything else...
worked for me...might not solve your problem though it wont do any harm:
<% Server.ScriptTimeout = 100 %>
|
|
|
|
chinh10
Junior Member
125 Posts |
Posted - 21 July 2001 : 15:32:47
|
I think you can easy convert from MS Access to SQL 7
In SQL program it has that function
Few click and that's it.
I alread tried to do that before everything is ok. No problem
|
|
|
|
Spoon
Average Member
Ireland
507 Posts |
Posted - 21 July 2001 : 16:18:22
|
quote:
I think you can easy convert from MS Access to SQL 7
In SQL program it has that function
Few click and that's it.
I alread tried to do that before everything is ok. No problem
There is no doubt about it, changing to SQL will speed it up.
In SQL there is an option to import your existing Ms access db. Close your forum for a few mins, download the database, import it to sql, Upload the new SQL database.
Don't forget to change your conn string in config.asp
Should work, open your forums,
Sorry in a rush.... lol
Regards,
Spoon, (ya all love me right?) |
|
|
| |
Topic |
|
Topic Locked
