dcsimg
Results 1 to 3 of 3

Thread: which type of DB in host is better

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Oct 2018
    Posts
    25

    Question which type of DB in host is better

    hello

    using from SQLite DB is better than Sqlserver DB or not?

    thanks

  2. #2
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    32,006

    Re: which type of DB in host is better

    That's like asking which is better, a hammer or a screwdriver... while both are tools (databases) they both fill different needs/purposes... there's somethings SQLite will be better at that SQL Server isn't at, and other things that SQL Server will be better at that SQLite won't be... so you're asking the wrong question in my opinion. What you should be doing is looking at your needs and then researching the capabilities of both, and then determining which one will better serve your needs.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  3. #3
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    100,975

    Re: which type of DB in host is better

    tg is completely correct but, given that this question has been posted in the Mobile Development forum, I will add one comment that may aid you in evaluating your needs and the capabilities of those databases. SQL Server is a service-based database system, which means a server must be installed with all the overhead that comes with that. If you want a database on a mobile device itself then SQL Server is not an option, but if your mobile app is going to connect to a web service then the power and flexibility of a full-scale RDBMS like SQL Server on the host server is likely to be advantageous. SQLite is a file-based system that is relatively powerful but can't do all that SQL Server can, but it can run with a fairly small footprint on a mobile OS. It's basically just a data file and a DLL.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width