Hi! I am first day with SOLR, and of course, i have some problems with it. I need to index a database, which is postgresql database. I defined fields in data-config.xml file, added DataImportHandler to solrconfig.xml, added postgresql jar to solr folder. But, when i am starting SOLR, i have the following error: 2009-10-27 16:08:53.28...
I have a table with a InTime and an OutTime column. Normally when I insert data into this table I set the InTime to a DateTime and the OutTime to null. When the data is removed a OutTime value is set. When I’m getting data out for a particular time I use something like: where InTime < sometime and OutTime is > sometime or OutTime is n...
I have a table(users) with columns as id INT AUTOINVREMENT PRIMARY uid INT index email CHAR(128) UNIQUE activated TINYINT And I'll need to query this table like this: SELECT * FROM users WHERE uid = ? AND activated = 1 My questions is, since there's an index set on the 'uid' column, in order to get the best performance for the abo...
I understand that indexes should get updated automatically but when that does not happen we need to reindex. My question is (1) Why this automatic udate fails or why an index become bad? (2) How do I prgramatically know which table/index needs re-indexing at a point of time? ...
I'm creating custom forum software for a site I'm building, which includes 2 tables (that are relevant to this question): topics and posts. A post belongs to a topic, and the topic contains the subject, while each post contains the body. Here is the basic table structures with the columns relevant to my question: CREATE TABLE topics (...
So I was reading up on indexes and their implementation, and I stumbled upon this website that has a brief explanation of b-tree indexes: http://20bits.com/articles/interview-questions-database-indexes/ The b-tree index makes perfect sense for indexes that are only on a single column, but let's say I create an index with multiple colum...
Here is what I have in mind: 1) Create a service that will run every hour or so and search for twits using a specific criteria 2) I also need to filter out garbage (index engine needs to be smart enough, kind of like anti-spam service) What are the best strategies/ideas to accomplish this? PS Any ideas if there is anti-spam engine a...
Hi folks, i have a field that contains guid's. They represent a user's PunkBuster GUID. Is it possible to create an index, on this field, which only index's the last 8 characters of the guid? The reason i'm asking is that you cannot to a full text search like => '*abcdef'. (at least I believe I read that somewhere ... was it Pro Full-...
MySQL table with couple of fields: id - PRIMARY KEY url - CHAR(255). url field is also unique and indexed. Currently have couple of hundreds of thousands entries in that table. MySQL gets really slow. The idea is: if I add hash BIGINT UNIQUE INDEXED field, and create composite index hash/url - will it work faster? Means will MySQ...
I'm trying to optimize my PostgreSQL 8.3 DB tables to the best of my ability, and I'm unsure if I need to use varchar_pattern_ops for certain columns where I'm performing a LIKE against the first N characters of a string. According to this documentation, the use of xxx_pattern_ops is only necessary "...when the server does not use the s...
Ok, been scratching my head on this one for a bit now... seems related to this ol' chestnut Here's my problem: var testlength = theForm.elements.length; var testlastelement = theForm.elements[testlength].type; testlength returns 60 BUT! testlastelement comes back as "undefined" (null or not an object) What gives? FWIW, my page ha...
On Query 1 a full table scan is being performed even though the id is an indexed column. Query 2 achieves the same result but much faster. If Query 1 is run returning an indexed column then it returns quickly but if non-indexed columns are returned or the entire row is then the query takes longer. In Query 3 it runs fast but the column...
I'm starting to get a much better grasp on PostgreSQL indexing, but I've run into an issue with the OR conditional, where I don't know how to go about optimizing my indexes for a faster query. I have 6 conditionals that, when run individually, appear to have a small cost. Here's an example of the trimmed queries, including query plan c...
I am getting a sqlserver Timeout in my aspx page. It comes when i click one of the link in the website. Will indexing will help with this problem? Thanks ...
Hey guys Just looking for some search and indexing services for our sites, and wondered if you guys could recommend anything? our requirements: The service can either index via http, or direct access to our database. It's gotta be just really simple to use, and set up provide a simple API so we can get the results programmatically an...
I am looking to write a static analyser for a university class. To provide more power for the tool I would like to be able to look up the call hierarchy (as Ctrl+Alt+H does in Eclipse). This would also have to be a fast operation, so the lookup would probably have to be done against an index rather than bytecode scanning. However, writi...
Is there a way to move an entity to another kind in appengine. Say you have a kind defines, and you want to keep a record of deleted entities of that kind. But you want to separate the storage of live object and archived objects. Kinds are basically just serialized dicts in the bigtable anyway. And maybe you don't need to index the arch...
hey guys ok, I'm totally new to SOLR and Lucene, but have got Solr running out-of-the-box under Tomcat 6.x and have just gone over some of the basic Wiki entries. I have a few questions, and require some suggestions too. Solr can index data in files (XML, CSV) and it can also index DBs. Can you also just point it to a URI/domain, and...
My gut tells me there is no good way to achieve this, but, unlike Mr. Stephen Colbert, I'd rather trust a community of developers than my gut... Is there a known way to efficiently implement a "best of both worlds" list, one that provides random access by index and O(1) insertion/removal like a linked list? I foresee two possible outco...
hey guys, just installed solr, edited the schema.xml, and am now trying to index it and search on it with some test data. In the XML file I'm sending to SOLR, one of my fields look like this: <field name="PageContent"><![CDATA[<p>some text in a paragrah tag</p>]]></field> There's HTML there, so I've wrapped it in CDATA. In my SOLR s...