Page 1 of 1

SQLite for medium databases?

Posted: Sat Dec 02, 2006 3:59 am
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.

Posted: Sun Dec 03, 2006 3:26 am
by dibyendrah
Don't worry about size of the database. SQLite supports upto 2 terabyte! :wink:

Posted: Sun Dec 03, 2006 12:27 pm
by pedrotuga
Nice! :)
Any experience on how it behaves with big amounts of data? Performance is the cool thing on mysql.

Posted: Sun Dec 03, 2006 11:28 pm
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

Posted: Mon Dec 04, 2006 11:48 am
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...