SQLite Databases and Grid Hosting

Posted by jocull on Stack Overflow See other posts from Stack Overflow or by jocull
Published on 2010-05-21T05:00:39Z Indexed on 2010/06/18 15:23 UTC
Read the original article Hit count: 262

Filed under:
|
|
|

I'm considering moving my site from a GoDaddy shared hosting account to a Media Temple grid hosting account in anticipation of traffic. However, I first have some concerns with the grid hosting setup.

My site stores a large personal set of data on a per-user basis (possibly 3-4MB per user). At this rate I was worried about blowing over a 1GB MySQL limit in no time. To deal with this I created distributed SQLite databases per user to store large data objects. It's worked wonderfully so far. SQLite is super fast and simple.

I know that reading from and writing to files is different in a Grid Hosting environment. I need to know if this setup is going to cause serious problems. These databases are not (and will not be) highly trafficked. They are personal to the user and will only be touched maybe two locations at the same time (one updating the data hourly at the most, and one or more reading on demand).

I'd like to keep this setup as getting additional space (beyond 4GB) on a MySQL database seems to be a real trouble point.

Will Grid Hosting cause me serious problems? Thanks.

© Stack Overflow or respective owner

Related posts about php

Related posts about sqlite