MySQL, MyODBC, Adding records slow?
- From: eselk@xxxxxxxxxxxx
- Date: Thu, 28 Jun 2007 16:06:14 -0700
I'm using VCL's ADO components to add records to MySQL server using
MyODBC driver. I've tried using TADOQuery with an INSERT INTO
statement. I've also tried TADOTable using Append(), with various
CursorTypes and CursorLocations... but so far I can only add about 2
or 3 records per second.
The records are less than 500 bytes each, about 10 fields. The table
has 6 single-field indexes -- all of the index fields are just INT
types.
I can do a 'SELECT *' from this table and all rows are returned in
less than 1 second, so I don't think it is related to my connection
speed to the server (high speed internet, about 1mbps upload and 5mbps
download).
I'm starting with a brand-new empty table each time (but I'm not
including the time it takes to DROP and CREATE this table in my INSERT
times). I'm only adding 96 rows, so it isn't like it gets slow over
time because it is a very large table.
Any advise? I'd like to stick with ODBC, or at least ADO, because I'd
like to make most of the code work with MSSQL and also JET/Access in
the future.
.
- Prev by Date: Re: Save Pdf to database
- Next by Date: Re: Save Pdf to database
- Previous by thread: Save Pdf to database
- Index(es):