Wondering if anybody has any experience using ODBC to go into an AS/400, now known as the iSeries.

We have no problem connecting w/ODBC and getting the job done, but have seen that the performance in a low-load situation is considerably less than SQL Server.

Generally, it is *very* hard to get an apples-to-apples comparison, but we have a dual-processor 500Mhz system w/NT running SQL Server 2000, and one of our baseline simple test queries, SELECT * FROM Mytable, will return about 3600 records/second. Doing the same query from the iSeries gives about 1200 records/second.

We have done a lot of tests, which I would be happy to go into if anyone asks, but at this point are hoping there might be an ODBC guru out there who can help us tweak it.

As always, TIA...
Ken