What DB should I use?
Posted on 1999-07-27
Hi, I'm developing a Real-Time TCP/IP Receiver and I want to put the data I receive into a database.
My first try was using the usual BDE with paradox tables. Not surprisingly, after receiving about 2 hours worth of data, I came up with a table of 35 MB in size. As expected, inserting into the table was VERY slow!!!!!!
The following is a list of components that I have available for this project:
ODBC98, ODBCExpress, Diamond Access, DBIsam, Flash FIller, Halycon, Apollo and Direct Oracle Access.
The following are the database servers (types) that I can use:
DBISAM, Access, MySQL (Windows / Linux), MS-SQL, Oracle, Fox Pro, Paradox, DBase.
Note: I receive aprox 15 records per second, so I need a FAST solution!
Could you please give me comments on what you would use and why?