Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Forums running reaaaaaaaally slow		  New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

omega1
Junior Member

United Kingdom
127 Posts
Posted - 29 March 2006 :  16:45:03  Show Profile  Visit omega1's Homepage
hi there,

been a snitz forum user for a few years, and have forums running on a few sites...

I have a problem that seems to have been getting worse and worse, and the forums are getting slower ans slower...

I have the latest version, running in access and the rest of the website is running relatively fast, just the forum that seems to be slow.

is there anythign I could look at or should I report it to my host?

Thanks for your commetns and advice.
Visit : My personal site - Website Hosting - Register a domain

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 29 March 2006 :  16:51:29  Show Profile  Send ruirib a Yahoo! Message
Probably time to upgrade from Access. Archiving some posts and compacting the database may buy you some more time. Do it and if it does improve, consider an upgrade.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

lasatalayas
Junior Member

109 Posts
Posted - 29 March 2006 :  16:52:20  Show Profile
As you using MS Access it's essential to regularly compacy your databases.
One way is to download them and compact&repair using Access itself whilst a second is to use Table Editor that allows you to compact them online on the Host.
Go to Top of Page

omega1
Junior Member

United Kingdom
127 Posts
Posted - 29 March 2006 :  16:57:13  Show Profile  Visit omega1's Homepage
hi, thanks for the commetns...

a few questions:

upgrade from access... to what?

also, could i have more info on the 'table editor'?

thanks for your help
Visit : My personal site - Website Hosting - Register a domain
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 29 March 2006 :  17:02:32  Show Profile  Send ruirib a Yahoo! Message
Upgrade path is either MS SQL Server (recommended, if possible) or MySQL.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

omega1
Junior Member

United Kingdom
127 Posts
Posted - 29 March 2006 :  17:04:56  Show Profile  Visit omega1's Homepage
my host doesnt support sql... bugger!
Visit : My personal site - Website Hosting - Register a domain
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts
Posted - 29 March 2006 :  17:08:48  Show Profile  Visit AnonJr's Homepage
Neither MySQL or MS SQL Server?!?

Sounds like it might be time to think of a new host. All the hosts I know of offer an upgrade path. Some charge extra, some don't. Even some of the free ones will let you upgrade - for a price.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 29 March 2006 :  17:10:42  Show Profile  Send ruirib a Yahoo! Message
MySQL is a possibily too. Personally I don't like it, but it works better than Access.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

lasatalayas
Junior Member

109 Posts
Posted - 29 March 2006 :  17:11:57  Show Profile
Table Editor 0.81
http://www.2enetworx.com/dev/projects/tableeditor.asp

For me it works really well as it enables you to exmaine all the tables on the remote Access Database and to compact & backup it. Also you can create your own SQL strings.
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts
Posted - 29 March 2006 :  17:15:04  Show Profile  Visit AnonJr's Homepage
All things being equal, I'd rather have MS SQL Server too. But, if its not an option or if the disparity in cost is enough its definitely a viable option.
Go to Top of Page

omega1
Junior Member

United Kingdom
127 Posts
Posted - 29 March 2006 :  17:34:59  Show Profile  Visit omega1's Homepage
i cant compact? i get a permissions error?

thanks

EDIT : i can get ms sql, its 10GBP per 1mb?!
Visit : My personal site - Website Hosting - Register a domain
Edited by - omega1 on 29 March 2006 17:35:45
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 29 March 2006 :  17:37:31  Show Profile  Send ruirib a Yahoo! Message
1 Mb of what?

I would advise you to either install Table Editor or shut down the forum, compact it using Access and upload it again to the forum.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

omega1
Junior Member

United Kingdom
127 Posts
Posted - 29 March 2006 :  18:05:34  Show Profile  Visit omega1's Homepage
1mb of space in the sql folder
Visit : My personal site - Website Hosting - Register a domain
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 29 March 2006 :  18:27:25  Show Profile  Send ruirib a Yahoo! Message
That's nothing, 1 MB?!!! An empty database allocates more than that!

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts
Posted - 29 March 2006 :  18:35:45  Show Profile  Visit AnonJr's Homepage
Just so I'm clear on something, is GBP a currency? I'm not quite as 'international' as I'd like to be at this point in time...
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 29 March 2006 :  18:38:07  Show Profile  Send ruirib a Yahoo! Message
Great Britain Pound.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.43 seconds. Powered By: Snitz Forums 2000 Version 3.4.07