• ddriver (7/19/2012)


    If you don't need that stuff and you can just use the embedded data store, just use SQLite and get on your way. This is worse than an apples to oranges comparison. More like apples to an apple stand.

    SQLite is great for what it does, I have used it many times. But I am not really sure about the utility of comparing it to SQL Server.

    A fair point. The reason I started looking into it is that I had been writing all of my applications against SQL Server until I started getting requests to write applications that would be used by only one at a time for certain niche functions. So, for those I started playing with SQLite, and readily having the option of either I wanted to know the performance implications of the choice.

    ---
    Timothy A Wiseman
    SQL Blog: http://timothyawiseman.wordpress.com/