| Author |
 Topic  |
|
|
RokDev
Starting Member
19 Posts |
 Posted - 23 May 2007 : 09:40:11
|
Hello,
I'm trying to convert an old version of the snitz forum (version v3.0 or v3.3 I think) from MS Access to SQL Server 2000 and the performance of the forum is now extremely slow. The home default page takes over a minute to display the page.
I've followed the steps in a previous post: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=63884 but I'm still experiencing performance issues.
There are only 40 forums - Access had no problem dealing with this but the SQL database is struggling.
Any help would be much appreciated.
Thanks
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
daveo
New Member
97 Posts |
Posted - 23 May 2007 : 10:28:41
|
| I am using SQL Server 2005. I converted using the tools that come with SQL Server and my forum runs great. |
http://copdforum.portalone.us/ |
 |
|
|
RokDev
Starting Member
19 Posts |
Posted - 24 May 2007 : 04:05:02
|
quote:
Originally posted by ruirib
Does that mean that you created the table structure by running setup.asp?RC=5?
|
|
|
|
RokDev
Starting Member
19 Posts |
Posted - 24 May 2007 : 04:09:21
|
Yes, I done this.
Once the structure was created I imported the data into the tables.
NB. I orignnally tried converting the Access Database into SQL without using the setup.asp method & initally experienced the same poor performance. I was hoping that the theory of creating the SQL tables first and tehn importing the data afterwards would be the solution.
Unfortunately not & am running out of ideas - perhaps the SQL statements need to be more efficient? This would surprise me though as the forum being used isn't overly large.
quote:
Originally posted by ruirib
Does that mean that you created the table structure by running setup.asp?RC=5?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 May 2007 : 04:26:10
|
Version 3.3.x is not very fast but that should not account for such a slow performance.
There are several possible explanations for that, most of them related to your SQL Server server hardware and / or load.
I would advise a migration to the latest version. It will improve performance meaningfully. I advise this because probably you have no way to test this in another server and very recently I saw performance improve greatly in a forum, just by upgrading from 3.3.x to 3.4. The scenario previous to the migration was very bad, with frequent timeouts, that ended once the upgrade to the new version was completed. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
RokDev
Starting Member
19 Posts |
Posted - 24 May 2007 : 06:36:29
|
Hi,
Thanks for the swift feedback.
I've now downloaded the latest swift forum (Version 3.4.06). I've connected to the existing SQL database. Problem is, it seems that this forum uses different fields, hence: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'F_LAST_POST_TOPIC_ID'.
If I start from scratch and create new data tables with the latest forum version will I have a problem importing my existing data due to the forum name discrepancies?
Thanks |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
RokDev
Starting Member
19 Posts |
Posted - 24 May 2007 : 07:23:00
|
It's super fast now since the upgrade to the latest version.
Thanks very much for your help. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
RokDev3
Starting Member
6 Posts |
Posted - 14 June 2007 : 11:48:14
|
Hello,
Following on from my previous post as RokDev (forgot password and can't find a way to retrieve it!!) I have got a problem with nt authentication with the new Snitz ASP code.
After a bit of investigation I notice that the mlev value is 0 (it should be 4 if it new that it was me and thereofore an admin.). Other interesting values returned are chkAccountReg=1, strAutoLogon=0, strLoginStatus= blank.
I would be grateful with some kind of direction as it's confusing me greatly.
Thanks, |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
