I want to develop a program that watches and traverses a rather big network for data. This data should then be available to search through with my program, maybe through a web interface or something. ...
I'm trying to find a tool (database system, library, etc.) which can help me with a variation of the inverted index/posting list intersection problem. The variation is that a record matches only if a ...
After you have done a good normalization, do you still need to index the table? How is this going to affect the performance? Will it even affect the performance in some way after a good normalization? ...
This might sound like a naive question but when are database table indexes in mysql required? How do such indexes affect performance and why?
I have a table with about 37 indexes. Would that be considered too many? What are some best practices regarding indexing? EDIT: It is warehousing data, updated daily with new transactions. There are ...
I have the following problem: I have a database containing more than 2 million records. Each record has a string field X and I want to display a list of records for which field X contains a certain ...