Announcement

Collapse
No announcement yet.

Is SQL Lite robust enough?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Is SQL Lite robust enough?

    Does anyone have any experience using a SQL Lite database with say, 100 concurrent users?

    Would that be a foolish thing to do when one has a MySql server available?

    The main thing I like about using a SQL Lite db is the simplicity of backup and restore (a simple file copy).

    I'm worried that it would be robust enough. This particular application would only have 3 or 4 tables and would use simple queries.

    Suggestions? Comments?
    Last edited by Shawn Anderson; 5 Oct 2008, 05:30 PM. Reason: typo

  • #2
    Originally posted by Shawn Anderson View Post
    Does anyone have any experience using a SQL Lite database with say, 100 concurrent users?
    If you are thinking of using naked SQLite for this, why not post on [email protected] and get it from "the horse's mouth"? Quite possibly the question has already been answered in that forum.

    Let us know what they say!

    Comment


    • #3
      Thanks Chris, I did.

      I've read many things, some conflicting, about concurrent users on a Sqlite database. The feeling I get is that Sqlite is good for a standalone desktop database, but should not be used in a concurrent user situation (like a website with many users).

      I'll let you know what sqlite-users say.

      Comment


      • #4
        Originally posted by Shawn Anderson View Post
        The feeling I get is that Sqlite is good for a standalone desktop database, but should not be used in a concurrent user situation (like a website with many users).
        I won't try to guess their answer, but Q5 in their FAQ is relevant. It would be interesting to test it with 100 users!

        Maybe a SQLite-based server such as SQLitening would help, have you thought about using it?

        Comment


        • #5
          Yes, #5 ( http://www.sqlite.org/faq.html#q5 ) exactly explains how this works. It looks like it could be handled.

          I'd love to find somebody with real-world experience with lots of users.

          Comment


          • #6
            There is also info on the SQLite site as follows:
            http://www.sqlite.org/whentouse.html

            Websites
            SQLite usually will work great as the database engine for low to medium traffic websites (which is to say, 99.9% of all websites). The amount of web traffic that SQLite can handle depends, of course, on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic.
            I bet that Fred and mine's SQLitening would work well for you. It is a pretty good client/server implementation of SQLite.
            Paul Squires
            FireFly Visual Designer (for PowerBASIC Windows 10+)
            Version 3 now available.
            http://www.planetsquires.com

            Comment


            • #7
              I wouldn't be too impressed by the hits per day statistic. The crunch comes when they all want to save data at the same time, like when it's time to go home.

              You're not powering the world's stockmarkets by any chance?

              Comment

              Working...
              X