Slower and slower

JavaJason · **Joined:** Thu Jul 22, 2004 4:32 am **Posts:** 31

Hi all:

There is 30,000 records in my database, and I use hibernate's paging strategy(setFirstResult() and setMaxResults()).
When I get first 10 records,It is fast. Or any 10 records in first 1000 records,It is also fast. But when I get 10 records in last 1000 records,It is very very slow, I don't know why?
who can tell me?

Any suggestion will be appreciate!

Hibernate version: 2.1
Database: MS SQL Server 2000
JDBC Driver: weblogic.jdbc.mssqlserver4.Driver
Web Server: Weblogic 8.1 SP3

anthony · **Posted:** Tue Nov 09, 2004 5:40 am

if you are using a long session, clear it every page

JavaJason · **Joined:** Thu Jul 22, 2004 4:32 am **Posts:** 31

Thanks for your replay, but I don't have a long session,

ArrayList al = new ArrayList();
//add 10 records to list
al.add(....);
al.add(....);
................
session.setAttribute("al",al);

JavaJason · **Joined:** Thu Jul 22, 2004 4:32 am **Posts:** 31

Who could tell me?
Why?