Hi!
I have some performance problems. Executing simple querys retrieving information from the database is slower than expected.
I'm using Windows XP wit BD2+JTOpen 7.0, SquirreSQL v. 3.1.2
This is the log that I receive for several SQL
Query 1 of 1, Rows read: 1, Elapsed time (seconds) - Total: 56.862, SQL query: 0.351, Building output: 56.511
Query 1 of 1, Rows read: 1, Elapsed time (seconds) - Total: 54.108, SQL query: 0.23, Building output: 53.878
Query 1 of 1, Rows read: 8, Elapsed time (seconds) - Total: 15.883, SQL query: 0.29, Building output: 15.593
Query 1 of 1, Rows read: 4, Elapsed time (seconds) - Total: 80.586, SQL query: 0.411, Building output: 80.175
Query 1 of 1, Rows read: 1, Elapsed time (seconds) - Total: 50.363, SQL query: 0.12, Building output: 50.243
How I can provide usefully into to fix this problem?