Re: Garbled data in response - reading from mySQL database

2009-10-03 Thread Lance Norskog
In general it is easier to use the DIH with a database view, rather than embedding the query in the DIH configuration file. On Sat, Oct 3, 2009 at 2:08 AM, Ade B wrote: > > Perfect, thank you. > > Ade > > > > -- > View this message in context: > http://www.nabble.com/Garbled-data-in-response---r

Re: Solr and Garbage Collection

2009-10-03 Thread Mark Miller
Just went back and looked - its even worse than that - it wasn't just slated for OpenJDK, it was already in OpenJDK at the time and released as GPL :) Granted, Sun's mistake was worse than mine (they used "permitted"), but the post that seemed to cause Sun to "reword" their release was all worried

Re: Solr and Garbage Collection

2009-10-03 Thread Mark Miller
Actually, now as I am remembering, I think the main give away away, as someone mentioned back when Slashdot had that misleading post, was that it was slated for OpenJDK - which is open source :) Typical Slashdot though. Mark Miller wrote: > Yup - I know - I remember the Slashdot discussion on it w

Re: Solr and Garbage Collection

2009-10-03 Thread Mark Miller
Yup - I know - I remember the Slashdot discussion on it well - I didn't mean it that way myself. It caused quite a stir, but most people figured out what they meant before they released any further info from what I could tell. I just made the same mistake they did :) Bill Au wrote: > SUN's initial

Re: Solr and Garbage Collection

2009-10-03 Thread Bill Au
SUN's initial release notes actually pretty much said that it was "unsupported unless you pay". They had since revised the release notes to clear up the confusion. Bill On Sat, Oct 3, 2009 at 2:51 PM, Mark Miller wrote: > Ah, yes - thanks for the clarification. Didn't pay attention to how > amb

Re: Solr and Garbage Collection

2009-10-03 Thread Mark Miller
Ah, yes - thanks for the clarification. Didn't pay attention to how ambiguously I was using "supported" there :) Bill Au wrote: > SUN has recently clarify the issue regarding "unsupported unless you pay" > for the G1 garbage collector. Here is the updated release of Java 6 update > 14: > http://ja

Re: Solr and Garbage Collection

2009-10-03 Thread Bill Au
SUN has recently clarify the issue regarding "unsupported unless you pay" for the G1 garbage collector. Here is the updated release of Java 6 update 14: http://java.sun.com/javase/6/webnotes/6u14.html G1 will be part of Java 7, fully supported without pay. The version included in Java 6 update 1

Re: Solr and Garbage Collection

2009-10-03 Thread Mark Miller
Another option of course, if you're using a recent version of Java 6: try out the beta-ish, unsupported unless you pay, G1 garbage collector. I've only recently started playing with it, but its supposed to be much better than CMS. Its supposedly got much better throughput, its much better at deali

Re: is it possible to speed up this query?

2009-10-03 Thread Yonik Seeley
On Sat, Oct 3, 2009 at 11:44 AM, Steve Conover wrote: > Hi, > > I have a query that's taking about 120ms to run that I'd like to try > to reduce if possible.  The key element that seems to be at the root > of about 100ms of the delay is a "not null" criterion (it happens to > be a Long field), i.e

is it possible to speed up this query?

2009-10-03 Thread Steve Conover
Hi, I have a query that's taking about 120ms to run that I'd like to try to reduce if possible. The key element that seems to be at the root of about 100ms of the delay is a "not null" criterion (it happens to be a Long field), i.e. foo:[* TO *] I've tried converting to trie ranges and that has

Re: debugQuery different score for same query. dismax

2009-10-03 Thread Yonik Seeley
On Fri, Oct 2, 2009 at 8:16 AM, Julian Davchev wrote: > It looks for "pari"   in   ancestorName  field   but first row looks in > 241135 records > and the second row it's just 187821 records. The "in 241135" is just saying that this match is in document #241135. -Yonik http://www.lucidimaginatio

Re: Garbled data in response - reading from mySQL database

2009-10-03 Thread Ade B
Perfect, thank you. Ade -- View this message in context: http://www.nabble.com/Garbled-data-in-response---reading-from-mySQL-database-tp25726655p25726976.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Garbled data in response - reading from mySQL database

2009-10-03 Thread Avlesh Singh
Change concat(i.name,'|',ih.name,'|',i.id) to *cast(*concat(i.name,'|', ih.name,'|',i.id)* as char)* Cheers Avlesh On Sat, Oct 3, 2009 at 1:51 PM, Ade B wrote: > > Hi > > I am using the DIH to import data from a mySQL database. Everything was > fine > in that I could index the data, and search t

Garbled data in response - reading from mySQL database

2009-10-03 Thread Ade B
Hi I am using the DIH to import data from a mySQL database. Everything was fine in that I could index the data, and search the index and return the correct results. However, I have just changed my database-config.xml file to add the primary key value of a table to a field composed of other value