| Author |
 Topic  |
|
trevork
Starting Member
United Kingdom
41 Posts |
 Posted - 19 August 2006 : 15:23:29
|
These may appear to be simple questions but please bear with me as I try to get my head around how this all works!
When the forum is up and running, am I right in thinking that all its content (threads, topics, replies etc) are stored on my own server? Or are they somewhere else?
What is the name of the file that contains all the forum content please?
Thanks in advance
Trevor |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 August 2006 : 15:51:06
|
Yes, the data is stored in a database that will be on your server.
If you're using Microsoft Access as your database, it's called: snitz_forums_2000.mdb |
Support Snitz Forums
|
 |
|
|
trevork
Starting Member
United Kingdom
41 Posts |
Posted - 20 August 2006 : 06:12:56
|
Thanks very much for that. Can I ask yet another simple question please?
My forum is so large in terms of threads etc that the search facility often times out. I would like to keep all the information available for searching but try and improve the actual search times. Is this possible? Is the answer connected to archiving? If so and I archive part of the forum, will a search still look at this and are the archived threads still accessible to users?
Thanks again
Trevor |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tomfassett
Starting Member
USA
35 Posts |
Posted - 23 August 2006 : 13:46:49
|
One of the responses here answered one of my questions as well (the one concerning archiving and speed). Thanks... 
Another brought up a question. Last year, we converted from Access to SQL (supposedly). I was told by a former admin that he took care of the changeover after our ISP converted the database. The forum did speed up drastically after that, especially when there are 30-40 simultaneous users. I noticed the other day that our database is still an mdb file, yet Davio mentions that this would be an Access database. I am paying for SQL--am I not getting it (I have my suspicions)?
Thanks,
Tom |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 23 August 2006 : 16:54:58
|
| Tom, check your config.asp file. MAYBE the mdb is just a redundant file that was never deleted ? |
|
|
|
tomfassett
Starting Member
USA
35 Posts |
Posted - 23 August 2006 : 22:44:57
|
Nope, the mdb database is the active one and the only one in the database folder. Nothing else is changed when new posts are made. I also compacted the database and this file went from 164Mb to 63Mb (I know--it should have been done long ago but we had a tech that was not doing any maintenance  ). Since I cannot find any SQL files, I assume the changeover was never made. Is this something I could do myself without ending life as we know it ( ), or should I have the ISP techs do it again (and just pay my money)?
What amazes me is that I was told running a huge Access database with so many simultaneous members was darn near impossible and the forum would run incredibly slow. True? Not true? The thing runs pretty darn fast now that I cleaned it up and ran all the "expected" maintenance.
Tom |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 August 2006 : 01:07:39
|
| You cannot assume anything, since SQL Server files won't be kept in any of the folders you can see. Check your config.asp and let us now what is the value of a variable with the name strConnString. There are several lines with possible definitions for this, right at the beginning of the file, only one of them being uncommented. That will tell you the database beung used. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
tomfassett
Starting Member
USA
35 Posts |
Posted - 24 August 2006 : 14:01:09
|
Gotcha'. The only references I see to SQL are uncommented.
Here is the string in question:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("...") '## MS Access 2000 using virtual path
Looks like Access to me (darn)... 
Tom F
|
Edited by - tomfassett on 24 August 2006 14:02:27 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tomfassett
Starting Member
USA
35 Posts |
Posted - 27 August 2006 : 12:25:43
|
I'm confused on the "commented" versus "uncommented" issue. If commented means the same a "rem" from the old days (), then I may have them backwards. Suffice it to say, the Access lines are active and the SQL lines are inactive (or remmed). Here is an example of an SQL line.
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL
I assume the apostrophe at the beginning makes this line of code inactive. Correct?
Tom F |
Edited by - tomfassett on 27 August 2006 12:30:26 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tomfassett
Starting Member
USA
35 Posts |
Posted - 27 August 2006 : 12:32:44
|
Oops, you responded before I could "clarify" my confusing post. You guys are too fast (no, scratch that--you are wonderfully quick in your responses...  ).
Tom F |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tomfassett
Starting Member
USA
35 Posts |
Posted - 27 August 2006 : 13:03:08
|
So I am back to assuming that the forum never got changed over to SQL as planned.
Thanks,
Tom F |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
