Hi all. I need to clean and fill periodically a database with several hundred thousands records readed from a plain ascii file. I have a Python script that opens the file and then, after a 'DELETE * FROM table' submits an INSERT for each registry, but this process is very slow. How can I accelerate this uploading process ? Best regards, Antonio Navarro Navarro BemarNet Management http://www.bemarnet.es [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]