Hi,

Generally, the problem is this. I run the same query twice. The first
time it takes 1 sec, the second time it takes 10min!

Details:

I'm using servlets, the query is run over the JDBC-ODBC bridge. The
actual database is contained in an excel spreadsheet.

For test purposes, the query is encapsulated in a single method - and
the method is called twice. It opens the database, runs the query and
closes the database. In other words, the following commands are given
twice:

     connect = DriverManager.getConnection("jdbc:odbc:MyData");
     Statement statement = connect.createStatement();
     ResultSet result = statement.executeQuery("select * from Data
order by ID, Date");

     connect.close();

Can anyone suggest what it can be?

Many thanks in advance,

Bura