Hello,
I have a Company table with 50 million rows that I am trying to index
with Hibernate search with

fullTextSession.setFlushMode(FlushMode.MANUAL);
fullTextSession.setCacheMode(CacheMode.IGNORE);

ScrollableResults results = fullTextSession.createCriteria(
Company.class ).setFetchSize(100).scroll( ScrollMode.FORWARD_ONLY );

while(  results.next() ) {
   curCompany = (Company) results.get(0);
   fullTextSession.index(curCompany);
               index++;
                if (index % 100 == 0)
                {
                fullTextSession.clear(); //clear every batchSize since
the queue is processed
                }
}

Above results in OutOfMemoryError. I looked at the Hibernate query and
there is no LIMIT clause. I am using MySQL 5.0.51g and Connector/J
5.0.6. Connector/J debug shows ScrollableResults enabled.

Thanks
H

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to