Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Search to determine existance of a record
I have a table with close to 1 million records. My program imports new records from a text file selected by the user into this table. The table has a field listing the name of the file that each record came from. Is there an efficient way to search the table to see if a file already exists i.e. see if the file has already been imported. I'm currently using a simple select statement that searches for the filename in question but that has become incredibly slow.
Kris H.
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