| Author |
 Topic  |
|
funinbc
Junior Member
245 Posts |
 Posted - 09 June 2005 : 17:35:08
|
This is more of a warning to people thinking of using this forum. I have been running this forum for a couple of years now and works fine if you do not have a lot of members but look out if you do. I have to phone my server every day sometime twice a day to have the ASP memory dumped. One reason for this is because I am using an access data base. If you are thinking using ACCESS DON’T!!!!!! not knowing how to convert to Mysql is leaving my site slower then a dieing dog.
I have asked for help on this site but all I get is finger pointing. Some on here say it’s my server’s fault and my server says it’s the fault of the forum. If you know ASP this will not be a problem as you can look at the code but if you don’t you WILL get into trouble with this forum.
Now I’m left a lot of unhappy people and a huge task in front of me to switch to another forum. DAM!
Thank you for letting me vent
|
|
|
mortioli
Average Member
United Kingdom
898 Posts |
Posted - 09 June 2005 : 17:52:59
|
| funinbc, drop me an email please, because your address you've put in your profile isn't recognised. |
 |
|
|
CalloftheHauntedMaster
Junior Member
289 Posts |
Posted - 09 June 2005 : 18:06:46
|
| Well, I can't really say I blame you, but my advice is to hire a programmer. A real, professional programmer, and get them to fully update your server. It'll cost you money, but that's pretty much the only safe way to do it. |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 09 June 2005 : 18:10:33
|
I would blame Access. I started on it a few years ago (always knowing it isn't bulletproof). Mods don't help the issue either, and every line of code should be read & understood ... well match the opens & closes anyway.
But I can see that moving to another forum might be the only choice in your case. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 June 2005 : 18:26:46
|
One should know the consequences of the choices one makes before ranting. Access is a nice desktop database, which I like a lot, but please don't expect it to handle I don't know how many concurrent users or to perform flawlessly with database with big sizes...though I've read reports of Access working perfectly with DB's in the hundreds of megs in good web servers.
There are instructions on how to upgrade to MySQL in these boards. People likely will help you for free to do it, or you can have the database upgrade for MySQL with someone being paid to do it professionally for a small fee (no, it's not me). You can vent, but your vent is a bit misplace, IMHO. You should be glad that you managed to make your forum so successfull with a free forum code and a free database!
P.S.: I do believe a decent host can make a difference. Also, if you have mods, it's likely that some of your mods may be causing you problems, but with a decent host, they can even help you find that out. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 09 June 2005 18:30:37 |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 09 June 2005 : 23:12:00
|
quote:
If you know ASP this will not be a problem as you can look at the code but if you don’t you WILL get into trouble with this forum.
This isn't true. Some (a few) users MAY have problems with Snitz. Most users DO NOT have trouble with this forum. Usually those who do have problems have problems that are caused by other issues with their server, not Snitz problems.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 10 June 2005 : 03:10:57
|
| maybe if you asked for some help rather than just ranting we would be able to do something, you don't give us a link or even indicate how busy your forum is, but undoubtedly your problems are related to Access and your webserver not Snitz |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 10 June 2005 : 03:12:14
|
| Oh and one more thing, there are several members of these forums including myself who offer hosting or run there own hosting company and therfore know a lot more about the effects of Snitz than most web hosts do. |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2085 Posts |
Posted - 10 June 2005 : 04:01:21
|
I have been running Classic Motorcycling Australia for years using access database and never had any issues, and with a heap of mods. I have been asked to change forums for other sites, but when I show the person who wants to use something other than Snitz what it can do, and on access, they are wrapped and stick with Snitz and are still with it.
Funinbc, if you do not know how to program properly, then you should not be programming. The only way you will get memory leaks from all I have seen over the years is so called programmers trying to cut corners and not do the right thing with their coding by closing items.
Just ask Neil from www.sportsfish.com.au with the way his old forum was from a bloke who did not program it right which had the CPU constantly sitting above 70% but with the release of the new forums he has with the coding I have done for him, it now sits below 7% and he is using MS SQL. So it is not restricted to Access. I know you have added mods to your site, as you have always asked for help.
I would chaeck your coding and you JavaScript before blaming Snitz forums for your memory problems in my opinion.
|
Cheers,
David Greening |
|
|
|
Roger Fredriksson
Average Member
Sweden
556 Posts |
Posted - 10 June 2005 : 04:55:07
|
I suppose I am one of those who shouldn´t be programming but I did it anyhow. So far everything is running nicely on www.avgifter.com/forum/portal_content.asp (Snitz/Image) but is that because of few users? In my old site I got 35 000 users and they are now in the Snitz-db (30 MB) but of different reasons few are using it right now.
Should I change to SQL or MySQL immediatly or give it a try with Access before marketing the site again? I forecast not more than 5-10 people to use the site concurrently. |
rf/www.avgifter.com |
Edited by - Roger Fredriksson on 10 June 2005 04:57:05 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 10 June 2005 : 05:05:47
|
Roger,
There are no major difficulties upgrading a forum from Access to SQL Server, even if I don't know Image's modded version. It's also possible to do it to MySQL, which I believe to be a bit more work, but it has been done with success before, and there will be people willing to help, for sure.
With no more than 5-10 people concurrently, and if your server is not overloaded, it's likely that Access will handle it well. Over time, DB size can increase, and you either delete some posts or move to a more robust DB. I have seen, as I wrote, people using several hundred megs Access DBs without a issue, of course, using reliable, non-overloaded servers. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Roger Fredriksson
Average Member
Sweden
556 Posts |
Posted - 10 June 2005 : 05:45:24
|
Tack rurib, I am hosting my site at Interland.com and most of the time it worked very well with my old entirerly "homebaked" site with the 25 MB db and 5 to 10 persons visiting. Service from my hosting company is very good so I think I will give it a try despite the warnings from funinbc (no adress?).
It would however be interesting to se lasers arguments for skipping Access as he seems to have a lot of experince too. |
rf/www.avgifter.com |
|
|
|
funinbc
Junior Member
245 Posts |
Posted - 10 June 2005 : 18:00:24
|
Sorry the forum address is http://www.funinbc.com/forum/default.asp
Yes I’m sure that it has a lot to do with the access data base. The site started small now I have around 60-70 people on at any one time. I am not a programmer but I have spent countless hours carefully putting a couple of mods in.
I only have good things to says about the very helpful people here!!! I just wish I started with Mysql as to move this over now is not an easy task! Not sure why the popular mods are not part of the basic forum.
Good luck trying to access the site as it’s hit and miss. Some times it will time out other times it will just take a long time to load. God help me if someone does a search.
I know you all are very skilled at coding but when you don’t know ASP and you make a mistake as it sounds like I might have done you are left with a very slow board
and why is there not a way to prune old posts? There should be a way to dump old posts after a certain time. All I have been able to do is archive them which DOUBLES the size of the data base. When you only have limited storage this is a problem.
|
Edited by - funinbc on 10 June 2005 18:03:47 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 10 June 2005 : 18:29:55
|
There is a facility to delet archived posts and repack your database, but since you have speed issues it is unlikely to work without timing out.
How big is your database ? |
|
|
|
taropatch
Average Member
USA
741 Posts |
Posted - 10 June 2005 : 18:32:23
|
quote:
Your forum:
536 of 703 Members have made 152469 posts in 32 forums, with the last post on 06/10/2005 3:26:43 PM by:
There are currently 10856 topics.
quote:
My forum:
528 of 984 Members have made 11013 posts in 16 forums, with the last post on 06/10/2005 10:46:28 by:
There are currently 1507 topics.
There are 8769 archived posts in 1189 archived topics
My forum seems to have fairly similar stats as yours although I do not think I have 50-70 concurrent connections. Would archiving topics help funinbc's forum performance? And do you have subscriptions turned on? Subscriptions slowed my forum down very early on so I turned that feature off.
My forum has been running well with an access db for over 3 years... knock on wood. |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 10 June 2005 : 18:39:43
|
| As mentioned many times here, Access is fine as long as you don´t have a lot concurrent users - I have a Snitz forum with over 100.000 posts at 40MB of size which is very fast on Access, but I never have more than 10 users at the same time. If I had 60-70 as you have, I would switch to MSSQL, the conversion is quite easy. Just ask for help. MYSQL is a little more complicated, but it can be done... |
|
|
|
Topic |
|
Topic Locked
