Hvilken DB og hvorfor?

Nu kender jeg ikke hastigheden i paradox, men Access er hellere ikke specielt hurtigt. Hvorfor ikke bruge en RIGTIG database? MSSQL eller MySQL. De yder langt mere, men der er også en prisforskel. MySQL er gratis, og fungere også via ODBC. De gør de begge, så du kan stadig skrive det i delphi.

Hmmm....jeg har hele tiden troet MySQL kun kørte på Linux...tror jeg kigger lidt på det...
Men er der ingen ulemper ved at bruge MySQL?

kobbernaqel en RIGTIG database! Access IS en rigtig database and more! This question has been up loads of times and there are always some who say that Access isnt a rigtig database! What is it then? Can you make a front end (user interface) in MySQL or MS SQL? No! What about transactions in MySQL? Maybe in the latest version!

Access IS a "rigtig" desktop database, and is in fact more than likley the most widely used database for destop applications AND also on the WEB! How can that be when it ISNT a "rigtig" database!

Access does have it limitations though, a theoretical 255 max users although 20-50 will be about right. Ii IS NOT a database SERVER like MySQL and MS SQL so if there are large amounts of data then it may go slow (2000 is NOT many records) it is limited to 2 GB databases but it can manage more than one dB at the same time.

So drgaa, IF you want to make a front end to your database then Access is just the job. Or you can use MySQL or MS SQL and do it with VB. Not as easy as Access though!
What you have to remmeber in ANY database is make sure you INDEX the fields you use most eften for querying (searching)

Min plan har hele tiden været at bruge Delphi til at lave et user-inferface, så jeg tror MySQL er helt rigtig (jeg skal bare finde udaf at bruge det ;-).
Jeg skal også lave en hel del komplicerede søgninger, og da DBen hurtigt kan blive større, lyder det til, at MySQL den bedste løsning (2000/år er cirka, det kunne hurtigt blive 10-20K/år - hvad anses for mange records?)
Fandt også informationen på denne side nyttig:
http://www.mysql.com/information/crash-me.php

In access over 500,000

Hvis jeg nu skal overbevise den person, jeg laver DBen for, at MySQL er bedre end Access - hvad skal jeg sige?

Personen ved intet om DBer ;-)

You dont say anything! I am NOT saying Access is better, I am saying they are two different products intended for two markets. They BOTH have there advantages and disadvantages. If you used Access then you wouldnt need to use Delphi, but if you used MySQL you would. Its NOT easy making your database in MySQL (no user interface) in Access its a piece of .... (cake)
Oh! another solution if its not for many users (5-10) is MSDE which is actually a version of SQL Server.