> ahh, thats a tip, should I commit after every table ? Like this? No, that's overkill. To give you an idea, in web-based systems, commit/rollback is usually done after the request is finished. -- Gustavo Niemeyer http://niemeyer.net