An index is a data structure that facilitates a faster lookup time.
2
votes
2answers
39 views
get index and add value to equivalent index
all i want here is to add value to index. for example i have a listbox and i put string to it using the collections in the properties, and if i choose the first string with index of 0 and then output ...
0
votes
1answer
12 views
Using Offline Indexing in SQL Server
I've written a .Net application which has an SQL Server 2008 R2 database with relatively small number of tables, but in some tables there might be some 100,000,000 records! For improving performance ...
1
vote
2answers
12 views
MySQL Indexes and possible_keys
I ran an EXPLAIN statement on one of my common queries I run, and I am curious why my "possible_keys" only match 2/3 of my indexed fields. Is this because im using a LIKE clause?
Here is a link to ...
0
votes
1answer
30 views
Using index to extract substring from an array in perl
I would like to use perl to extract 30 character substrings from an array, using another array that consists of indices where I would like the substring from each line to start. For instance, Line 1 ...
0
votes
3answers
46 views
How to find the largest N elements in a list in R?
So I have a list of floats in R. For a given integer N, I want to find the indicies of the largets N values in my list. So for example, if N is 2, I want to find the indicies of the two largest values ...
1
vote
2answers
28 views
Bash: Find position of character in a string under OS X
Is there any way to find a position of a first character within a string in Bash under Mac OS X?
Something like:
stringZ=abcABC123ABCabc # 6
echo `expr index "$stringZ" C12` ...
2
votes
0answers
24 views
Disable Google Indexing the HTTPS version of our website naked domain
We're on Google App Engine, and due to some technicalities, we're unable to serve on https://feeltracker.com
We know that http://feeltracker.com and http://www.feeltracker.com work fine however.
...
google-app-engine
1
vote
2answers
32 views
Does columns order in multiple columns unique constraint make any difference? Is it justifiable to have duplicate indexes?
In "SQL Certified Expert Exam Guide" by Steve O'Hearn I've found this paragraph:
In the rare instance when you create a composite index along with multiple constraints that call on the same index, ...
0
votes
0answers
8 views
extract the content excerpt from Apache solr
I have used Solr for my Mysql table to index as well as search.Now i want to get an excerpt from the matched results and also high lighten it .
Where Do i have to make changes
is it here ? if yes , ...
3
votes
0answers
36 views
Drupal with Near Realtime Search Solr
I have to implement Near Realtime search for Solr, strictly connected with Drupal. After add/edit each node, trigger should run Solr to index new content ( via soft commit) , without rebuilding whole ...
1
vote
3answers
39 views
How can I find listbox item index with item value?
my
MessageBox.Show(listbox.Items[0].ToString());
is
"abber"
how can I find listbox item index 0 with "abber"?
0
votes
1answer
26 views
Best way to index a table in Oracle
Is it a good practice to have multiple index for same column in a table?
Eg. There is table A with column col1,col2,col3,col4,col5,col6
Indexes
Index1 on (col1,col2,col3)
Index2 on ...
1
vote
1answer
25 views
Mysql/php - Is it possible update a table with a loop but without a key?
Is it possible to make a procedure that update rows in a mysql table without a primary key?
I have a table like this, that correspond to teachers's schedules:
TEACHER_ID | WEEK_DAY | HOUR | CLASS
...
2
votes
1answer
22 views
MySQL query not using index
I have a MySQL query that is running very slowly because it's not using an index on the join key. What is wrong with my table structure that the optimizer is not using the index?
mysql> EXPLAIN ...
3
votes
3answers
72 views
Replace function used in index
What happens to an index built on a function when I change the underlying function?
Say, I have a function clean_name() defined as:
CREATE OR REPLACE FUNCTION clean_name(n text)
RETURNS TEXT AS
...
0
votes
1answer
28 views
sort multiple columns according to particular order
I have a matrix
A = 1 1 1
2 2 2
3 3 3
4 4 4
5 5 5
I have 3 arrays containing the orders in which I separately want to sort the respective columns. Example I1 ...
0
votes
0answers
37 views
List index out of range, using incremental values
I'm having trouble finding out what's wrong with my code.
for row in excelreader: #Writes info to new file.
for item in row:
file.write("<"+attrlist[y]+"="+item+' ')
...
0
votes
1answer
10 views
JavaHelp does the indexer need the content of the html pages to index?
I have successfully created an online help in my application using JavaHelp.
At the first step I have created the example from JavaHelp so I had the typical menu with animal information.
In the next ...
0
votes
2answers
42 views
Indexes for mongodb
I have a mongo db collection for restaurants.
e.g.
{_id: uniquemongoid,
rank: 3,
city: 'Berlin'
}
Restaurants are listed by city and ordered by rank (an integer) - should I create an index on city ...
0
votes
0answers
14 views
Uncaught exception 'MongoCursorException' with message … duplicate key error index:
Here's my code:
When i try to work it, there's an error as it:
"Fatal error: Uncaught exception 'MongoCursorException' with message
'localhost:27017: E11000 duplicate key error index:
...
2
votes
1answer
20 views
How to avoid bloating transactionlogs while creating an index?
Does anyone know to avoid bloating transactionlogs while creating an index?
My problem:
I have a script that creates a lot of Indexes. While running this script, my transactionlog doesn't stop ...
0
votes
2answers
18 views
mongodb: why indexOnly=false when collection is empty
Let's say I have an empty db without any collections. Then I run db.qqq.ensureIndex({a:1}).
In the output of db.qqq.find().explain() I see BasicCursor and "indexOnly" : false. That seems OK.
...
1
vote
1answer
17 views
$index, in Table, not sequential… angularjs
I have a table in HTML.
The rows are counted (via use of $index), and only certain rows are shown (via use of ng-show).
Problem: $index does not return the right count. The table's count should go ...
0
votes
1answer
15 views
mysql add key does not work
I have this query:
SELECT adressid, adressname FROM kino_adressen WHERE city ='Seattle'
I wanted to create an index like this
ALTER TABLE <tablename> ADD KEY index_abc(adressid, ...
1
vote
0answers
24 views
When do I use another type index than integer? (eg string) [integer vs string index] [migrated]
I was reading about relational databases like sqlite and I always see the schema for user storage like:
UserID (index) | Username | Password
but wouldn't it be actually much faster to use Username ...
0
votes
1answer
5 views
gnuplot use index in the function(tanh) in for loop
I'm trying to make command for gnuplot.
from column 8 to 33, using tanh
so I tried below command
plot for [i=1:26] 's0' u 1:(i*0.1+2):(tanh($(7+i))) w l lw 3 palette notitle
it doesn't work.
So I ...
-2
votes
2answers
56 views
Inverted Index in Python not returning desired results
I'm having trouble returning proper results for an inverted index in python. I'm trying to load a list of strings in the variable 'strlist' and then with my Inverse index looping over the strings to ...
0
votes
0answers
11 views
Doing a full-text index on a view with ntext columns
Is there any way of creating a full-text índex on a view that has ntext columns?
It doesn't make any sense to not have this available.
0
votes
0answers
8 views
In BTree, could it improve read performance by storing blocks continuously?
In our use case memory/cache is small, and we want to improve read/load (from-disk) performance by storing btree blocks consecutively on disk...
The observation is that to lookup a key or a data ...
0
votes
4answers
37 views
Index of a dynamic created list Javascript
i have a dynamically created list with data of a json.
So my question is how to get the index of a clicked item.
I tried this:
$("li").click(function() {
var index = $("li").index(this);
...
