Menu

#889 Application too slow building output

open
nobody
None
5
2012-12-29
2010-07-09
No

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?

Discussion


Log in to post a comment.