JDBC updates extremely slow. Why?

[nycguy]

Im doing a simple update on 1 field on a number of records, and it takes a minimum of 15 seconds per record to do the update. Multiply this by a few records and it takes minutes, sometimes half an hour or more to update 100 records or so.

The database has 12,000 records in it. I'm using standard PreparedStatement and the executeUpdate() method.

Why is it so slow? Is there any way to speed it up? Or is this just normal JDBC performance? If so, JDBC is a terrible solution.

Anyone have any ideas?

[Anatoli]

RE: If so, JDBC is a terrible solution.

So is ODBC.

I do not know how it will be in next FM (7 or X), but only direct FM operations are fast and also the CDML based are fast.

Maybe also XML in FM6 is fast.

[omiossec]

The jdbc implementation of Filemaker use the web companion to work and the web companion do not allow multiple delete/modify in one request. So the jdbc driver have to make on search request on loop on the records set to update records one by one.

The only things you can do is to use a layout that only use field needed by the update