• Registered: 2006-04-30
  • Posts: 382

Topic: sqlite database oversized?

I have two forums on the same server... one uses sqlite another mysql.
I used sqlite on the smaller one beacause my hosting provider has kind of a shitty mysql server... it used to get slow and it went down a lot.
Big irony, lately the mysql server has been performing ok and my forum that has an sqlite database is getting locked all the time. The pages take so long to load that the request times out.
I am wondering if that has to do with the database size... the file is about 50mb now... is that to much for an sqlite database? I have about 14 users at the peak hor.

  • From: U.S.A.
  • Registered: 2005-08-26
  • Posts: 1,607

Re: sqlite database oversized?

I'm not sure how much (if at all) it will help your problem, but you might consider taking a look at this: http://www.sqlite.org/lang_vacuum.html

As always, remember to back up your database file first.

Looking for a certain modification for your forum? Please take a look here before posting.