[b]Hibernate version:[/b] 1.2.0 Alpha1

[b]Mapping documents:[/b]

[b]Code between sessionFactory.openSession() and session.close():[/b]

[b]Full stack trace of any exception that occurs:[/b]

[b]Name and version of the database you are using:[/b] Microsoft Access

i'm experiencing low performance with this simple line of code on a table with 1.131.000 records


int count = (int) session.CreateQuery("select count(*) from mytable").UniqueResult();

i expected it runs in milliseconds: instead it take a lot of time to return; i think it read all the records and then
retrieve the count

is it possible ?

I doubt that. Enable SQL logging and look at what SQL is generated.