I may be a bit off the mark. It seems that DataImportHandler may be able to do this very easily for you. http://wiki.apache.org/solr/DataImportHandler#jdbcdatasource
On Fri, Oct 24, 2008 at 6:28 PM, Simon Collins <[EMAIL PROTECTED]> wrote: > Hi > > > > We're running solr on a win 2k3 box under tomcat with about 100,000 records. > When doing large updates of records via solr sharp, solr completely freezes > and doesn't come back until we restart tomcat. > > > > This has only started happening since putting mysql on the same box (as a > source of the data to update from). > > > > Are there any known issues with running solr and mysql on the same box? When > it's frozen, the cpu usage is around 1-2% not exactly out of resources! > > > > Am i best using something else instead of tomcat? We're still trialling solr > (presently, used for our main site search www.shoe-shop.com and search and > navigation for our microsites ). It's an excellent search product, but I > don't want to fork out on new hardware for it just yet – until i know how > more about the performance and which environment i'm best to go for > (win/linux). > > > > If anyone has any suggestions/needs more info, i'd be extremely grateful. > > > > Thanks > Simon > > ________________________________ > Simon Collins > Systems Analyst > > Telephone: 01904 606 867 > Fax Number: 01904 528 791 > shoe-shop.com ltd > Catherine House > Northminster Business Park > Upper Poppleton, YORK > YO26 6QU > > www.shoe-shop.com > > ________________________________ > > This message (and any associated files) is intended only for the use of the > individual or entity to which it is addressed and may contain information > that is confidential, subject to copyright or constitutes a trade secret. If > you are not the intended recipient you are hereby notified that any > dissemination, copying or distribution of this message, or files associated > with this message, is strictly prohibited. If you have received this message > in error, please notify us immediately by replying to the message and > deleting it from your computer. Messages sent to and from us may be > monitored. > > Internet communications cannot be guaranteed to be secure or error-free as > information could be intercepted, corrupted, lost, destroyed, arrive late or > incomplete, or contain viruses. Therefore, we do not accept responsibility > for any errors or omissions that are present in this message, or any > attachment, that have arisen as a result of e-mail transmission. If > verification is required, please request a hard-copy version. Any views or > opinions presented are solely those of the author and do not necessarily > represent those of the company. (PAVD001) > > Shoe-shop.com Limited is a company registered in England and Wales with > company number 03817232. Vat Registration GB 734 256 241. Registered Office > Catherine House, Northminster Business Park, Upper Poppleton, YORK, YO26 > 6QU. > > This message has been scanned for malware by SurfControl plc. > www.surfcontrol.com -- --Noble Paul
