Results 1 to 5 of 5

Thread: Which DB ?

  1. #1
    Join Date
    Jun 2004
    Posts
    2

    Question Unanswered: Which DB ?

    what DBMS do you think its best for local system ?

    i know Access but I heard its kind of slow on DB that has 1k elements, So what do you suggest ?

    thank you for your time.

  2. #2
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346
    Try the free SQL Server named MSDE from microsoft. You get the power and speed of the full SQL server but are limited to 25 similtaneous users.
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848

    Well...

    but are limited to 25 similtaneous users.
    MSDE allows unlimited simultaneous users. However, it does employ throughput throttling when the number of concurrent users is more than 8. The additional users aren't rejected; their queries just run "slower."

    Ref http://techperformanceadvisor.com/doc/09585

    The workaround for this limitation is to utilize batch type processing, and to have the users connect, run their queries, and disconnect. Although you'll have some additional time required to actually connect/disconnect from the server, the performance hit is relatively small. When you think about it, this type opf approach actually makes a lot of sense anyway. Most users pull data, then spend minutes or hours perusing it, before actually needing to access the database again.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  4. #4
    Join Date
    Jun 2004
    Posts
    2
    I still can't find a perfect db for my application

    i think sql server is not for local system, its for server application ( remote system).

  5. #5
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    MSDE will SUPPORT network access, but it's not required. It works just FINE as a single user service.
    Last edited by loquin; 07-19-04 at 17:01.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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