Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re^5: SQLite performance

by jbert (Priest)
on May 02, 2007 at 10:52 UTC ( #613153=note: print w/replies, xml ) Need Help??


in reply to Re^4: SQLite performance
in thread Perl solution for storage of large number of small files

I disagree. SQLite is a 'database of first resort'. It doesn't scale to the same heights as server-based approaches, but those heights are quite a way off for the majority of systems and it's performance is good when you stay within it's scaling limits. The docs are also up-front about when you *don't* want to use it.

Using sqlite in a solution simplifies the solution compared to server-based RDBMSs (fewer moving parts and fewer deployment/management issues) and so reduces the costs and time spent dealing with it.

So unless you:

  1. already have existing server-based database infrastructure
  2. know in advance your expected load is approaching the limits of sqlite
  3. or particularly need a feature one of the server-based RDBMSs provides
I'd say that choosing MySQL or postgres over sqlite is premature optimisation.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://613153]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (5)
As of 2022-08-14 09:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?