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]