netbeans huge result set
HI friends....
I am trying to display a huge table on a webapplication.
the table in my database has 2.5 million records which i want to parse using the pagination buttons. what i actually want is after displaying a couple of record on the page, i would want to search the whole 2.5 million records against a parameter that i provide from the text field.
the problem is i could not find any prefetch methods in the netbeans gui.
i have been searching the forum and for setFetchSize(int) and setMaxRows(int) which didnot help in any way.
i would appreciate if anybody would share a solution to this problem.
thanx in advance...
Limit the results in the sql query (pass another parameter to limit the results)
SELECT * FROM db1.tableA WHERE colA='rofl' LIMIT 0, 100;
Take a look at the documentation on the LIMIT clause for SQL. You can specify offset and how many results you want returned. You can combine this with other clauses to further refine the data returned.
Hey friends...
i think i found the solution for my problem,
the netbeans gui provides a property PAGESIZE(int) which allows me to set the value to 100 and i can get a resultset with atmost 100 results.
What are you going to do when you aren't running your program in NetBeans anymore?
> What are you going to do when you aren't running your
> program in NetBeans anymore?
No problem. When it comes time to deploy your app, first install NetBeans on the target machine.
> No problem. When it comes time to deploy your app,
> first install NetBeans on the target machine.
Awesome idea! :-P
> > No problem. When it comes time to deploy your app,
> > first install NetBeans on the target machine.
>
> Awesome idea! :-P
When I can install NetBeans on an iPhone, I'm gettin' me one of them.
you can do a lot on an iphone... including hack them but i think they are too expensive
> you can do a lot on an iphone... including hack them
> but i think they are too expensive
It's worth it. When I can install NetBeans, I can develop code whilst zipping along on my Segway:
http://www.segway.com/products/
> It's worth it. When I can install NetBeans, I can
> develop code whilst zipping along on my Segway:
>
> http://www.segway.com/products/
Segway's are worth it though i got to ride one around Epcot they are so much fun scary at first but fun i think they are more worth the money than iphones
> > It's worth it. When I can install NetBeans, I can
> > develop code whilst zipping along on my Segway:
> >
> > http://www.segway.com/products/
>
> Segway's are worth it though i got to ride one around
> Epcot they are so much fun scary at first but fun i
> think they are more worth the money than iphones
Oh yeah. Only chumps walk.
> Oh yeah. Only chumps walk.
Agreed ;) I saw a cop pull over a car on one the other day that's a funny sight
> > Oh yeah. Only chumps walk.
>
>
> Agreed ;) I saw a cop pull over a car on one the
> other day that's a funny sight
OMG, I'm being ticketed ... by a nerd!
