Hi there! I have this drupal website that revolves around a document database. By design you can only find these documents by searching the site. But I want all the results to be indexed by Googlebot and other crawlers, so I was thinking, what if I make a page that lists all the documents, and then tell the robots to visit the page to i...
I have a course search engine and when I try to do a search, it takes too long to show search results. You can try to do a search here http://76.12.87.164/cpd/testperformance.cfm At that page you can also see the database tables and indexes, if any. I'm not using Stored Procedures - the queries are inline using Coldfusion. I think I...
From what I understand the data will be "persisted" (physically stored, not just retrieved when i need it). Is this correct? If so what would be the advantage of using an indexed view versus just using a table? ...
I have these entity kinds: Molecule Atom MoleculeAtom Given a list(molecule_ids) whose lengths is in the hundreds, I need to get a dict of the form {molecule_id: list(atom_ids)}. Likewise, given a list(atom_ids) whose length is in the hunreds, I need to get a dict of the form {atom_id: list(molecule_ids)}. Both of these bulk lookups...
I understand that full text indexing and search for a database can be enabled by a lot of pre-packaged products. However, just out of academical curiosity, I wonder how are those full text indexes actually implemented. I have tried to google for results with little answer. Please any feedback would be much appreciated. ...
I'm not intimately familiar with CCK but I have a one-time custom setup and know that I could get some performance gains if I created indexes and changed the field type and length of some of the fields in my CCK table. Is it save to modify this table at all or will I end up destroying something in the process? Thanks ...
How should I index a date column when some rows has null values? We have to select rows between a date range and rows with null dates. We use Oracle 9.2 and higher. Options I found Using a bitmap index on the date column Using an index on date column and an index on a state field which value is 1 when the date is null Using an index...
Hi, I'm using the searchable behaviour from the bakery. It is all set up correctly with no errors, so there is no problem there. However when preforming a search it returns no results. I'm at a loss as to why this is happening because of a lack of any errors. I think it might have something to do with initial set up or the indexing o...
I was analizing a query (working on a wordpress plugin named nextgen gallery), this is what I got query: EXPLAIN SELECT title, filename FROM wp_ngg_pictures wnp LEFT JOIN wp_ngg_gallery wng ON wng.gid = wnp.galleryid GROUP BY wnp.galleryid LIMIT 5 result: +----+-------------+-------+-------...
hey ppl, i am new to r language.. so i just want to know how array indexing is done in r language , i mean like sorting or any calcultaions that involve 2-d arrays. ...
This is the query (a search query basically, based on tags):- select SUM(DISTINCT(ttagrels.id_tag in (2105,2120,2151,2026,2046) )) as key_1_total_matches, td.*, u.* from Tutors_Tag_Relations AS ttagrels Join Tutor_Details AS td ON td.id_tutor = ttagrels.id_tutor JOIN Users as u on u.id_user = td.id_user where (ttagrels.id_tag in (210...
I was just wondering which field type would be the best solution for storing a timestamp in a MySQL database. Currently I store timestamps in an INT (10) field and insert the time by doing UNIX_TIMESTAMP(). If I was to use a timestamp field would it be slower or quicker when indexed? I know both fields use 4 bytes. ...
I am trying to create an index on a particular text string using Hibernate annotations. What I am currently doing is: @Index(name="guid_index") @Column(length=1400) private String myGUID; However, since the length of the column is 1400, this maps to SQL using the longtext type. hbm2ddl is able to create the table without mishap, but w...
I have a field called 'sort_order' and it's bigint, i use it in my mysql queries for sorting. Is it wise I put an index on it? ...
Hi, I have lots of documents, PDFs, etc. in a file server which I need to be indexed and searchable from a web interface like a search engine. Any ideas on any software that might do the trick? Thanks ...
i've read this article for ajax indexing how can i do to read the state in a url like this with rails? ex. http://mysite.com/controller/action#!pid=1237604&id=1079297234 the state is: pid=1237604&id=1079297234 thanks ...
How words break in the full text indexing process depends on what language you use, right? Now let's say I want to add a breaking character that usually is not, in any language. Example: I want words to break at the letter a how do I accomplish that? And let's also say I have a word that I want to act as a wordbreaker, for example th...
Hello everyone, I have some doubts regarding sitemap.xml generation and Django's sitemap framework particularly. Let's say I have a blog application which has post_detail pages with each post's content and a bunch of 'helper' pages like 'view by tag', 'view by author', etc. Is it mandatory to include each and every page in sitemap....
Hi Gods, i have a multilanguage site. Unfortunatelly the site was done when i learned that i need to you sub domains for different language versions (or sub directory, or different domain..) Now, i have no time, and money to change the sturcutre of the site. If i make a search in google in english, than its ok. But if i made in my lan...
Like the title says, I'm trying to find elements of M that exist in the large constant array N. Most of the time, no element of M will exist in N, so the vast majority of searches done on M are a waste of time. I'm looking for some way to create an index to check before doing a full-scale search of M. A project similar to mine creates a...