SQLite for medium databases?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
pedrotuga
Forum Contributor
Posts: 249
Joined: Tue Dec 13, 2005 11:08 pm

SQLite for medium databases?

Post by pedrotuga »

I have a database with two months and it is about 150mb. I estimate that in the future it will grow about 200mb a month.
Is this two big for using sqlite or should i just go for it?
I would absolutly prefer sqlite rather than mysql. I am sick of the network layer thing. It's anoying, specialy because i am in shared server and i cant set up things my way.
User avatar
dibyendrah
Forum Contributor
Posts: 491
Joined: Wed Oct 19, 2005 5:14 am
Location: Nepal
Contact:

Post by dibyendrah »

Don't worry about size of the database. SQLite supports upto 2 terabyte! :wink:
User avatar
pedrotuga
Forum Contributor
Posts: 249
Joined: Tue Dec 13, 2005 11:08 pm

Post by pedrotuga »

Nice! :)
Any experience on how it behaves with big amounts of data? Performance is the cool thing on mysql.
User avatar
dibyendrah
Forum Contributor
Posts: 491
Joined: Wed Oct 19, 2005 5:14 am
Location: Nepal
Contact:

Post by dibyendrah »

Sorry pedrotuga. I don't have experience on SQlite. Mostly, I use MySQL. I'm planning to work on SQlite because it will be very easy deploying the project using SQlte.

Cheers,
Dibyendra
ody
Forum Contributor
Posts: 147
Joined: Sat Mar 27, 2004 4:42 am
Location: ManchesterUK

Post by ody »

pedrotuga wrote:Nice! :)
Any experience on how it behaves with big amounts of data? Performance is the cool thing on mysql.
Now that depends completely on the structure of the data and the person managing the database. But as with any tool in the right hands...
Post Reply