i have an app that has to update two table with pdf files from directories. There are about 900 files in one Dir and about 3000 in the other. I have to check if each file is in the table if not add it. This requires 3000 searches on the table but as the app progresses it slows down to a crawl. Anybody have any ideas?.
I have to add to this the revers for deleted files, so I really could do with speeding up the loop. The list below is the milliseconds it takes to do 100 hundred records. There are no updates in the trimmings just locates bob Pointon ====================================== IPACTA_TRIALS_PDFS 0 109 203 266 328 500 531 610 ====================================== IPACTA_LABELS_PDFS 0 110 297 250 328 422 578 579 718 750 813 937 1000 1063 1094 1250 1328 1406 1453 1516 1578 1718 2047 1907 1875 2031 2032 2187 2250 2344 2406
*********************************************************************** NOTICE: This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential or privileged information. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify the sender and delete the e-mail and attached documents. Thank you. ***********************************************************************
_______________________________________________ Delphi mailing list -> [email protected] http://www.elists.org/mailman/listinfo/delphi
