Good Morning every one;
I'm attending to apply indexes concept using c++ text files.
I need to create two text files, one for index, the other for data records.
I should insert/delete records to the text file according to physical address of the line, not to the number of the line in the text file.
My problem is to get the address of the line I need to insert/delete from.
...
2 results in 0.0045 seconds.
-
Retrieving the address of a record in a text file
-
Right amount of indexes to use on a big table?
One of my applications collects a lot of data and is outputting it to a group of analysts that view it in all sorts of ways. To speed up things we've been using a lot of indexes on our main tables.
At some point, i wonder what kind of problems we can run into with all these indexes we've created.
What's the a good number of indexes for tables with over 10 million rows? Do the number of indexes have an impact on queries...
