CODEWITHSUNDEEP
javamysqljdbc
srisar
srisar

Reputation: 1571

How to get whole lot of rows of data from MySql and show it on Java application?

I have a Mysql database with 100 rows of data in a table. I have created a Java application (Swing) which displays the data in JList, but I am wondering if I load thousands of rows of data, The performance of the app will be reduced right?

If so what is the best way to display the data or query the data?

Thanks in advance.

Upvotes: 0

Views: 81

Answers (1)

Peter Wooster
Peter Wooster

Reputation: 6089

You want to paginate the data, ths is easy to do with MySQL. Just use the LIMIT and OFFSET in the query.

Upvotes: 2

Related Questions