This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
the default sql show data shows 20 rows of data; in my case there were over 9million pages of 20 rows of data per page. when i clicked >| to go to last page it never returns -- it acts like it wants to advance 1 page at a time to the last page -- over 9million pages. no way to stop the access. when clicking the X in lower right to stop task seems to not work; when exiting netbeans the thread/process keeps running; had to kill netbeans to get the network activity to stop
Hey, please provide the DBMS you are using and whether direct queries are really faster. I strongly suspect, that the DBMS is the problem. I created a test mysql db with 289055054l entries. With only one bigint column. This is a unoptimised test run directly against the db (without JDBC): mysql> select * from t1.tx limit 289055054, 10; +-----------+ | x | +-----------+ | 288999981 | | 288999982 | | 288999983 | | 288999984 | | 288999985 | | 288999986 | | 288999987 | | 288999988 | | 288999989 | | 288999990 | +-----------+ 10 rows in set (5 min 24.02 sec) As you can see this is already pretty slow and netbeans can't get it faster. For other thing you mentioned (not being able to cancel the query) please see bug #159929 (already fixed for 7.3). Seeing both informations together I'm inclined to close this bug as WONTFIX (the nearest think to NOTABUG in other bugzillas).
Thank you very much for evaluation, Matthias. I'm closing the bug as you suggest. Emiddio, please reopen if you can assure us that the issue is not caused by database performance. Consider profiling the IDE while showing the data ("Profile the IDE" button in the main toolbar) and attaching NPS snapshot. Thank you.