1951
General Software Discussion / Re: Reindexing in the background software for databases
« Last post by Contro on July 06, 2014, 09:50 AM »With Oracle there are systems in place that do maintenance tasks such as (re-)index tables when a database is idling. That is because this consumes a lot of resources and it is better that during (re-)generation as little none to as little amount as possible database transaction take place so indexes are not (too) messed up afterwards.
The online documentation with MS-SQL Server already warns against creating too much indexes as they are more likely to degrade performance than enhance it.
Enterprise class databases don't even do what you want...or warn against these practices at least.
Ath is right, proper applications don't need continuous indexing.-Shades (July 03, 2014, 12:13 AM)
I "remember" somewhere in this forum talk about EveryThing . This program fullfill my requirements about locate in my hard disks. Even talks about more powerful apps able to look inside pdf files, and even scan documentation and create text and indexes.
But for me was enough EveryThing.
I don't need certainly remember what I did- usually - a few moments ago. Or a week ago....
So a working copy of my databases perfectly indexed a week ago is enough for me.
