At my work we have various web pages that, my boss feels, are being ranked lower than they should be because "mywebsite.org/category/" looks like a different URL to search engines than "mywebsite.org/category/index.php" does, even though they show the same file. I don't think it works this way but he's convinced. Maybe I'm wrong though...
On DBD::SQLite of SQLite3 If I am going to query a SELECT only once. Should I CREATE a INDEX first and then query the SELECT or just query the SELECT without an INDEX, which is faster ? If need to be specified, the col. to be index on is a INTEGER of undef or 1, just these 2 possibilities. ...
Add extra wrap in Alphabetical site index Situation described in the code. I think my problem is the right scope, but i don't how to solve it. Thanks a lot. # # Alphabetical site index # # @see http://typo3.org/documentation/document-library/extension-manuals/cl_alphabeticalindex/0.1.3/view/toc/0/# # @note typoscript/templates/ext/cl_...
I recently took over a project and they have a SQL job setup to run every three hours which rebuilds the indexes found within the ASP.NET Membership database tables. This seems pretty high, to rebuild indexes 8 times a day. I get about 2000 new users every day, and a total of about 2 million registered users. What would you recommend ...
How can I retrieve the positions of the selected item in a multichoice listView ? The getSelectedItemPosition method returns only the first one... ...
I have an app where basically I have a huge table (100 million records) of information, with each row containing a lat/long value. I'm constantly querying this table to get all the records that fit within a radius around a certain point. For example, "all records within 5 miles of 39.89288,-104.919434" For this, I have an index over th...
I am using and working on software which uses MySQL as a backend engine (it can use others such as PostgreSQL or Oracle or SQLite, but this is the main application we are using). The software was design in such way that the binary data we want to access is kept as BLOBs in individual columns (each table has one BLOB column, other columns...
I have a large document with various sections. Each section has a list of keywords /phrases of interest. I have a master list of keywords/phrases stored as a String array. How can I use Solr or Lucene to search each section document for all keywords and basically give me which keywords were found ? I cant think of any straightforward wa...
I would like to write a dictionary. What algorithms/structures should I use? Each word or phrase has a corresponding description (examples, videos, images, and more). It should be possible to easily add/remove words and modify description. Quick access is more relevant than quick adding/removing. It should be possible to filter words o...
Is it possible to overload C++ class operators in the static context? e.g. class Class_1{ ... } int main() { Class_1[val]... } ...
I often use the string search feature for an entire solution in VS2008. Is there a way to improve its search speed by getting VS2008 to index all the source code and config files, similar to how Google Desktop index files? ...
I have a select in which I do a "group by". One of the columns is an enum, and I want to select the biggest value for each group (i.e the one with the largest index in the enum). I can do select MAX(enum_column+0) as enum_index to get the the largest index in the group, but how can I turn the enum index back to the enum item? Exam...
I know how to use INDEX as in the following code. And I know how to use foreign key and primary key. CREATE TABLE tasks ( task_id INT UNSIGNED NOT NULL AUTO_INCREMENT, parent_id INT UNSIGNED NOT NULL DEFAULT 0, task VARCHAR(100) NOT NULL, date_added TIMESTAMP NOT NULL, date_completed TIMESTAMP, PRIMARY KEY (task_id), INDEX parent...
I have a series of questions about Keys, Indexes and Constraints in SQL, SQL 2005 in particular. I have been working with SQL for about 4 years but I have never been able to get definitive answers on this topic and there is always contradictory info on blog posts, etc. Most of the time tables I create and use just have an Identity colu...
I have two tables defined below. Create table tickets (id long not null, reseller long not null, constraint pk_lock primary key (id)); Create table ticketRegistrations (id long not null, customer long not null, constraint fkTicketRegistrationTicket foreign key (id) references tickets (id) on update cascade); The client can input ...
Here's the background: Version: Oracle 8i (Don't hate me for being out of date. We are upgrading!) SQL> describe idcpdata Name Null? Type ----------------------------------------- -------- --------------------------- ID NOT NULL NUMBER(9) DAY ...
I have 169 towns for which I want to iterate a macro. I need the output files to be saved using the town-name (rather than a town-code). I have a dataset (TOWN) with town-code and town-name. Is it possible to have a %let statement that is set to the town-name for each iteration where i=town-code? I know that I can list out the town-...
Hi, I have a latex document. I am using hyperref, makeidx and glossary packages for my document. Every thing is created fine; table of content (all references works nicely), glossary and index except that page numbers printed in the glossary and index are correct but they point to page numbers starting from the beginning of the documen...
I would like to rename an index. I've looked at the alter table documentation, but I can't figure out the syntax to simply rename an index. When doing it through the MySQL GUI, it drops the index, and creates a new one. While this works, I would like to avoid rebuilding the entire index just to change the name of an index. [ADDITIONA...
We have a large table, with several indices (say, I1-I5). The usage pattern is as follows: Application A: all select queries 100% use indices I1-I4 (assume that they are designed well enough that they will never use I5). Application B: has only one select query (fairly frequently run), which contains 6 fields and for which a fifth ind...