Hi Dan
Dan Armbrust wrote:
The MySQL drivers are horrible at dealing with large result sets -
that article gives you the workaround to tell it to bring the results
back as they are needed (like it should in the first place) but I have
found that it isn't reliable - it tends to drop out at random points
during the query - so you will get a different number of rows each
time you rerun the query. In MySQL - the only reliable way I have
found to get all of the results from a large table is to use their
"limit" keyword in the query, and only ask it for X (I usually use
10,000, but use whatever works best with your system) number of rows
as a time, and then keep rerunning the query, incrementing up the
start position of the "limit" keyword. This issue also varies a lot
from version to version of the driver - some versions have been
completely broken, and others are only slightly broken. To bad we
can't get lucene quality code everywhere :)
The incremental query seems to work better. Thanks.
>> Exception in thread "main" java.io.IOException: Access is denied
To me, that really seems like you have an issue with the location that
you are writing the index to. I would make sure you have full write
permissions to the location, and make sure there aren't some old /
invalid files sitting in there.
Oh Im really quite tired of trying to resolve this "Access denied"
issue. Ive deleted and recreated the index directory umpteen times!
Finally I created a brand new directory in a brand new location and ran
my index program. Lucene seemed to index the results from the first
30000 queries (increments of 10000) successfully but then finally threw
this age-old error yet again !! .. Can you or anyone else make any
sense of this? I surely cant !
Also the indexing seems to be noticeably slow. For indexing every 10000
result sets by allocating 1.4gb of memory at run time, it takes
approximately 20 seconds. With a database of a million records the total
time in indexing will take ~ 35 mins. Is that normal?
Thanks
Rahil
Dan
___________________________________________________________
Try the all-new Yahoo! Mail. "The New Version is radically easier to use" The Wall Street Journal
http://uk.docs.yahoo.com/nowyoucan.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]