Groovy Question

[vijaya bacina]

Hi
we are planning to use Groovy and Grails for a small project
we had a table with million records. Is it OK to create a Domain class for that table and use findby methods to retrieve data?
does the server gets all records and convert them to objects while start up or how it works . im confused.

[Mark Herschberg]

I believe the findBy method is implemented with either SQL or HQL statements under the covers. I think (meaning I can't remember if I read it in the docs or if it was discussed in the grails mailing list) that you can paginate through the results so can avoid getting them all back at once if it's a large results set.

Grails will not create objects for all database records on startup unless you explicitly code such behavior.

--Mark