OK. Here is what is happening. When the indexing starts it selects the first 1000 records to add to the index. These seem to be added to the index. When it has added the 1000th record another select appears in the log file to get the rest of records (There are 1561 records in the table):
SELECT * FROM (SELECT TOP 561 * FROM (SELECT TOP 1561 * FROM persons) AS tmp1 ) AS tmp2 However this select doesn't get the records from 1001 to 1561. It get 1 to 1000. So these first 500 or so records are added to the index twice but the final 500 are never added. -- Posted via http://www.ruby-forum.com/. _______________________________________________ Ferret-talk mailing list [email protected] http://rubyforge.org/mailman/listinfo/ferret-talk
