On Tuesday 23 January 2007 17:30, jrmrenegade wrote:

> Having faster prep statements is nice, but the latency of the internet
> connection (150 ms for me) completely negates that.  It doesn't appear
> that there is a clean self-contained solution here

if that roundtrip time is the major bottleneck, a very hacky solution would be:

create table temp (
row1_1 int,
row1_2 int,
row2_1 int,
row2_2 int
...

insert into temp values (row1_1, row1_2, row2_1,
row2_2, row3_1, row3_2, ...);

and a trigger on temp which inserts into your table1.

At least it reduces the number of round trips

or you write into a fixed record length file, transfer that to the
server and import it via an external table. That would be just one
insert statement.

--
Wolfgang