• Post Reply Bookmark Topic Watch Topic
  • New Topic

Paging

 
Gitanjali MJ
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I'm using mysql ver 3.23 for paging of my resultset in jsp ie., showing 10 - 10 records.I use temporary table of type heap.
The time taken to view those 10 records is very slow and abruptly the temporary table is dropped always ...
My database server has already occupied 94% of space does this effect the temporary table creation.

Does anyone have an idea how to go abt it.
firstly the perfomance and secondly abt the temporary table
 
Chetan Parekh
Ranch Hand
Posts: 3640
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

My database server has already occupied 94% of space does this effect the temporary table creation.


First, please do something with this, make more space. Do the de-fragmentation if possible. Do truncate tables if possible.

Second, check following site, it has free JSTL that you are looking for. Check the demo portion.

Tag Library for Pagination
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 65533
108
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Gitanjali",

There aren't may rules that have been put into place here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
Forum Bartender
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!