[EMAIL PROTECTED] wrote: > > I am currently investigating porting my project from postgres to SQLite due > to anticipated performance issues >
I do not thing speed should really be the prime consideration here. PostgreSQL and SQLite solve very different problems. I think you should choose the system that is the best map to the problem you are trying to solve. PostgreSQL is designed to support a large number of clients distributed across multiple machines and accessing a relatively large data store that is in a fixed location. PostgreSQL is designed to replace Oracle. SQLite is designed to support a smaller number of clients all located on the same host computer and accessing a portable data store of only a few dozen gigabytes which is eaily copied or moved. SQLite is designed to replace fopen(). Both SQLite and PostgreSQL can be used to solve problems outside their primary focus. And so a high-end use of SQLite will certainly overlap a low-end use of PostgreSQL. But you will be happiest if you will use them both for what they were originally designed for. If you give us some more clues about what your requirements are we can give you better guidance about which database might be the best choice. -- D. Richard Hipp <[EMAIL PROTECTED]>
