logo       
Google Custom Search
    AddThis Social Bookmark Button

Re: GOODS speed: msg#00115

Subject: Re: GOODS speed

On Dec 15, 2004, at 9:26 AM, danil a. osipchuk wrote:


I converted it to PostgreSQL running on FreeBSD box - rock solid and
much, much faster. Then I needed to deploy the whole app on a laptop for trade show (On windows), so I converted it once again to SQLite. Rock solid, but very
slow for those same large queries...


Postgresql.org announced native server for nt-based systems (although I didn't try it) They even provide installer :), see: http://www.postgresql.org/docs/faqs/FAQ.html#1.4
So I wonder - what advantages have SQLite  against postgres right now?

The main advantage is only if you need to distribute your app lot's of places... SQLite has no server process; you basically need one shared library and your database file. You have all the capabilities of Squeak with file systems to manage your data infrastructure, and don't need any kind of admin access to get your database running. It also makes it very easy to prototype things for the same reasons.

I would usually prefer the PostgreSQL option for performance and name recognition if given the choice.

Thanks for the info, that is good news about the Windoze port!

Brian



wbr,
   danil

_______________________________________________
Seaside mailing list
Seaside@xxxxxxxxxxxxxxxxxxxxxxxxxx
http://lists.squeakfoundation.org/listinfo/seaside



Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>