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: 282
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