Server Fault Stack Exchange
Server Fault Stack Exchange

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?
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…
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?
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…
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…
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…
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;…
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…
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?
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…
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…
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…
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…
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…
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…
Neil Aitken
  • 93
  • 1
  • 8
1 2
3
4 5 6 7