I'm working on optimizing my site for Google's search engine, and lately I've noticed that when doing a "site:www.joemajewski.com" query, I get results for pages that shouldn't be indexed at all. Let's take a look at this page, for example: http://www.joemajewski.com/wow/profile.php?id=3 I created my own CMS, and this is simply a break...
Hallo. I have a big video file. ffmpeg, tcprobe and other tool say, it is an h264-stream in an AVI-container. Now i'd like to cut out small chunks form the video. Problem: The index of the video seam corrupted/destroyed. I kind of fixed this via mplayer -forceidx -saveidx <IndexFile> <BigVideoFile>. The Problem here is, that I'm now ...
I have a long list of items (say, a few million items) in a mysql table, let's call it mytable and it has the field mytable.itemid. The items are given an order, and can be re=ordered by the user by drag and drop. If I add a field called mytable.order and just put numbers in them, it creates problems: what if I want to move an item betw...
Went searching and didn't find the answer to this specific noob question. My apologies if I missed it. In a MySQL database I have a table with the following primary key PRIMARY KEY id (invoice, item) In my application I will also frequently be selecting on "item" by itself and less frequently on only "invoice". I'm assuming I would ...
I have indexes for my table user,date, and date,user but when I issue queries like SELECT * FROM table WHERE date >= '2010-5-1' and user='test'; It doesn't use the date,user index it uses the user index. Is there any way to get mysql to use the date,user index for these queries? ...
What is the best way to achieve Lucene real-time indexing? ...
Hi. I'm trying to define a property that is not the id as a clustered index in nhibernate, yet I've found no way of doing this. Could anyone give me a pointer of how this is done, or it is something not currently available in nhibernate? Thanks in advance ...
I have some tables in Oracle enviroment which I have found could benefit from new indexes. However, they are big tables, ranging from 1M registers to 300M registers, so I would first try to estimate how much time it would take for the index creation take place, so I would know at least the order of magnitude it would take (hours, days, w...
Alright, PHP is throwing this error (in the log) and it's quite detrimental to the application. PHP Notice: Undefined index: sessid in methods.php on line 7 Yes, I'm aware of what this error means, what I cannot figure out is why it's obviously defined and saying it's undefined. Here is the relevant code in methods.php $sessid = mys...
Hi, I am having some trouble deleting documents from Solr index. I use following code: try{ $solr->deleteById('1'); $solr->commit(); $solr->optimize(); }catch (Exception $e){ echo $e->getMessage(); } This code sometimes succeeds, but most of the time the following exception message is retur...
Hello, i want to list all propertys available to the searchable plugin in a small form. Is there a smart way to list all indexed properties by lucene/compass? Imagine this grails domain-class: class Person { String realname String login static searchable = { realname() } } It would be nice to get a list li...
I'm creating/changing a ton of indexes on a large db. Doing this works if the index already exists. CREATE UNIQUE CLUSTERED INDEX [table1_1] ON [dbo].[table1] ([col1], [col2], [col3]) WITH DROP_EXISTING ON [PRIMARY] But if it does not exist the errors. So I have changed my script to: IF EXISTS (SELECT name FROM sysindexes WHERE name...
Hi, http://api.jquery.com/index/ Is there a way to use jQuery index() method to find the index of an element related to the overall document? I mean, if I have a bunch of img tags in a document, is there a way to know, regardless of their position in the document, their index? example : <body> <img /> <div> <img /> <div> ...
I appreciate this is an incredibly noob question, but having Googled multiple combinations of search terms I regretfully am still in the dark. These things can be difficult when one doesn't know and so obvious when one does. I have semi-home page where incoming customers can choose to see a queried list or do a handful of other things. ...
I'm using eclipse to work on some c code and it is not indexing code inside conditional compilation blocks like this: #ifdef USE_FEATURE_A int feature_a(...) { some = code(here); } #endif How can I get eclipse to index the feature_a function? ...
I thought this was straight forward, but given a multi-dimensional array string[,] table = new string[,] { {"Apple", "Banana", "Clementine", "Damson"}, {"Elderberry", "Fig", "Grape", "Huckleberry"}, {"Indian Prune", "Jujube", "Kiwi", "Lime"} }; How can I return a specific ar...
I have id, member_id, topic_id fields. Sometimes I use id, sometimes member_id and sometimes topic_id in WHERE clauses. Can I add Indexes to all of them? Will it make it slower? I am new to MYSQL optimization stuff, so thank you. ...
HI!! as the question says, I would like to get some frequently occuring phrases with lucene. I am getting some information from txt files, and am losing a lot of context for not having information for phrases eg. "information retrieval" is indexed as two separate words. What is the way to get the phrases like this? I can not find anyth...
I'm sure it must have been asked before, but I can't find it: I have a CMS that is under constant development. I have built a number of websites using the CMS, so their are a number of databases in existence. I want to extract the indices from the development db and apply them to the production dbs. Is there an easy way to extract indi...
I am having a problem with striping punctuation from the solr index When the punctuation sign follow right after a word then this word is not indexed properly. For example: if we index "hello, John", the asset won't be found by keyword "hello" while there will be no issue if we remove comma after word "hello". Is there any FilterFactor...