Gossamer Forum
Home : Products : DBMan SQL : Discussion :

My db running very slow! HELP Please!

Quote Reply
My db running very slow! HELP Please!
When there are 2 people trying to access my guestbook db, the speed slows to a crawl. Any more than 2 and you might as well not have the damn thing at all! I'm working on indexing a few of the keys hoping this will speed things up (I had nothing indexed before). What else can I do? I'm assuming it's not the DBManSQL interface, but the database itself. It contains 33,750 records with an .ISD file size of 26MB. I've looked at many MySQL doc sites and also have the O'Riley book "MySQL and mSQL" trying to find ways of improving performance. I'm trying them all but nothing seems to be working. I'm pulling my hair out!!!! If anyone has a db anywhere close to the size of mine and everything seems to be running fine for you with multiple users accessing the data, please help! Or anyone with any suggestions are greatly appreciated. With all the time I've spent on this project, I don't want to have to scrap it and start over with something else!

AJ

Subject Author Views Date
Thread My db running very slow! HELP Please! TheFew 3697 Jun 26, 2000, 10:20 AM
Thread Re: My db running very slow! HELP Please!
Stealth 3510 Jun 26, 2000, 9:56 PM
Post I may have fixed most of the speed problems...
TheFew 3518 Jun 26, 2000, 10:48 PM
Post Re: My db running very slow! HELP Please!
ogrady 3526 Jun 27, 2000, 11:48 AM