DB type advice

[Arsench]

Hello world,
Im going to create a DB which have a many tables and records (more 100 000)what kind of DB file you can advice?mdb, paradox or ???


Thanks

Arsen Khachatryan
-------------------------------
Las circustancias de esta vida nos pone en una situacion dificil para comprender, que es lo que queremos...

Submit your sait free
http://www.khaarsen.com

[jamiguel77]

ì recommend you use mysql...

http://delphi.about.com/od/mysql/MySQL_with_Delphi.htm
http://www.programmersheaven.com/articles/Kalali/Mysql_tut-p1.htm

other way is firebird or postgreSQL but i preffer mysql

accept if help you

[BitFarmer]

I always use FireBird, you already have component to use it and instalation is straight, and it is powerfull, we have customer running with 12GB or even larger DB without problems.

Also, it allows you to use Embeded sql server: Drop a DLL near your exe and the program works, even from a pen drive without installation (install it if you need several computer to use this DB).

MySQL is near the same, but it is not real open source (the program belongs to a company), and the sql motor inside is far more complex in MySQL (they have several old pseudo-modes, quick and dirty ones, and a "real usable" one with consistency checks and all this, while FireBird only has a good one that works for everything).

Also, FireBird is slighty better in concurrency: Several people working on the same record is better managed that in MySQL: for instance, you can make a online backup perfectly congruent of a large DB while people is actively working and modifying the data, you don't need to stop people working before starting the backup.

Anyway, it is nearly the same, and sure MySQL fans will know things it does better that FireBird, for instance, if you plan to deploy your DB in a web server, surely they have MySQL server in your internet provider, but not FireBird, so in this case, don't use FireBird if you don't run the HTTP server your self!