Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I have several tables of 1 million+ records that are frequently replaced in their entirety. When this is done, they are all indexed on every single field.
In one instance, indexing a 1 million record file on 183 fields can take from 5 hours (process running on server) to over 15 (over crowded LAN).
I thought: Wouldn't it be cool to have a multiple key indexer that reads records only once and builds multiple keys as it goes, allowing only a single pass through the file which results in a complete CDX.
If, by any stretch, someone has something like this, please let me know. If anyone else has the same need and would like to collaborate on getting it written, let me know also and we'll see if we can crack it.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement