I have a Delphi 2010 vcl database application that uses NexusDB as the database server. The application iterates through a series of search terms, finds documents with those terms (separate process), and then loads a record for each document that contains the document id, the terms offsets (location in the document), and other metadata about the document. I have using table objects to insert and post the new records one at a time. I moved from that to using a stored procedure to perform the inserts; however, still one at a time. Does anyone have a suggest that could be more efficient?
