ORMLite vs pure SQLite select performance

[Sebastian]

I have database created with ormlite:

When I do query from sqlite console:

select * from records

 result is: 

3520 rows returned in 87ms from: SELECT * FROM `records`

Now I do same in ORMLite:

DatabaseHelper.get().getRecordsDao().queryForAll();

It takes around 70s for this query to finish.
Why is there such big difference???

And yes I have primary key ..
Also creating DAO takes only few miliseconds..

[Kevin Galligan]

Code for your objects, please. You probably have foreign eager fetches happening.

--
You received this message because you are subscribed to the Google Groups "ORMLite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ormlite-user+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.