I have written a nested query. when i run this query using prepared statement, type 4 driver it takes alomst 15 minutes to run from java code whereas it takes only a second when run directly on sqlserver query analyzer. it is just this query in java code that is taking so much time. No problem at all with any other query in the same piece of code what can be the reason ?
any ideas? thanks Lusha
posted 9 years ago
can u upload the code, are you sure it is the qry execution consume time not the data manipulation after execution of the qry ?