Questions tagged [indexing]
94 questions
2
votes
2 answers
Fancy Indexing with Apache
I would like to know how you might achieve this look with Apache's Indexing??
Is there a module I can get?
![](../../users/profiles/23988.webp)
Scott
- 123
- 3
2
votes
0 answers
The wait operation timed out
I have encountered this problem when running a Data-fill routine for a Data-set Data-adapter in C# which uses a stored procedure written in SQL Server Azure.
The SQL Server stored procedure executed directly from SQL Server Management Studio took…
![](../../users/profiles/313580.webp)
jpWebLearner
- 21
- 2
2
votes
2 answers
How to fully live update sphinx indexing?
It's covered in sphinx documents:
http://sphinxsearch.com/docs/manual-0.9.9.html#live-updates
But after reading it,I don't think it really can achieve that.
Have you guys ever also thought of this problem?
![](../../users/profiles/9377.webp)
abcgreen
- 159
- 1
- 8
2
votes
0 answers
How to index document files in NAS storage?
I'm currently developing an application that have to index document files (.pdf and .doc) which are in NAS storage. After that I want to query them over the application. My customer does not want to upload these files somewhere else.
Can Sql Server…
![](../../users/profiles/164379.webp)
Ogun
- 133
- 1
- 4
2
votes
1 answer
Sphinx searchd: failed to lock .spl file, no such file or directory
I use sphinx for indexing on my development environment, and it is working fine. But when i take it to the server. I can index and I have the indexes with search working on them, but everytime I run the command: searchd --config configfile , it…
![](../../users/profiles/149396.webp)
user1673575
- 121
- 2
2
votes
1 answer
What exactly is "pinning" in relation to indexes?
When one talks about "pinning" in indexes, what exactly is this? Is there some other word/term I can search for, as google has not provided any solutions.
It is part of a test question, where students were asked to define and describe pinning in…
![](../../users/profiles/123228.webp)
Database User
- 21
- 2
2
votes
3 answers
odd query strings in Googlebot requests
Google's indexing bot (edit: yes, it's Google, IP resolves) seems to be adding arbitrary query strings to our home page.
xx.xxx.xx.xxx - - [30/Jun/2009:10:14:37 -0400] "GET /?key=61680 HTTP/1.1" 200 3334 "-" "Mozilla/5.0 (compatible; Googlebot/2.1;…
![](../../users/profiles/584.webp)
ceejayoz
- 32,469
- 7
- 81
- 105
2
votes
4 answers
Which is the best Windows XP tool for indexing the hard disk?
After trying Windows 7, I miss the start menu search in my Windows XP. I don't like the Windows XP search because I think it requires much mouse work to get a search done, and it's indexing isn't fast enough. I already tried in the past a Google…
![](../../users/profiles/958.webp)
Jader Dias
- 4,625
- 18
- 48
- 50
2
votes
2 answers
Indexing windows server for searching
Is there a way to index file shares on a windows file server so that they can be quickly searched by end users, that isn't part of sharepoint?
![](../../users/profiles/13287.webp)
Brett G
- 2,023
- 1
- 27
- 45
2
votes
3 answers
When I modify the index in slapd.conf the same LDAP query does not return the data
I am using openLDAP on a CENTOS server.
To test I use JMETER with LDAP query and my software using thoses entry.
I want to optimize a particular request, I heavily search an OU attribute : description. The search use the l attribute to find it…
![](../../users/profiles/56180.webp)
Sylario
- 101
- 1
- 11
2
votes
6 answers
when do I reindex my MySQL database?
My (MySQL) database is experiencing intermittent lock timeouts. I do not have a root cause yet and we do not have any recommendations yet. Back in the day I would have to reindex my SQL Server and Oracle indexes because they needed it. No one ever…
![](../../users/profiles/47241.webp)
Richard
- 161
- 1
- 2
- 8
2
votes
3 answers
Large insert/update in table causes timeout while SQL Server re-arrange indexes
We insert/delete about 1 million rows of a two million rows table with SSIS.
We have 20 indexes on this table.
Right after the SSIS finished, we're experiencing timeouts in the frontend.
The timeouts eventually go away.
I'm suspecting the indexes…
![](../../users/profiles/48925.webp)
Mike Gleason jr Couturier
- 140
- 1
- 7
2
votes
3 answers
Mysterious timeouts in MSSQL 2000
I have a query that has been working fine for ages (2+ years).
All of a sudden it went from taking 3 secs to 30+ to execute. The table indexes have minimal fragmentation, but rebuilding the indexes "fixes" it for about a day.
When I go to check the…
![](../../users/profiles/6871.webp)
KellCOMnet
- 245
- 2
- 11
2
votes
3 answers
MySQL : table organisation for very large sets with high update frequency
I'm facing a dilemma in the choice of my MySQL schema application. So before I start here is a picture extremely simplified of my database :
Schema here : http://i43.tinypic.com/2wp5lxz.png
In one sentence : for each customer, the application…
![](../../users/profiles/64354.webp)
Remiz
- 135
- 6
1
vote
1 answer
Lock timeout when creating index
I am attempting to create a new index on an existing table with 44,485 records in it.
I am using this query to create my new index
CREATE INDEX index_name ON table_name (field_name);
Whenever I run this I get this timeout error:
1205 - Lock wait…
![](../../users/profiles/3122.webp)
Neil Aitken
- 93
- 1
- 8