3dbc has asked for the wisdom of the Perl Monks concerning the following question:
I am interfacing a dBASE - Xbase system using DBD ODBC with PERL DBI. DBD Xbase is too slow therefore DBD ODBC is preferred. Please correct me if I am wrong but, How can the limitation with DBD ODBC where only 1,800 unique updates can be completed in one sustained process be circumvented? The error received is that there is some sort of memory limitation. I have a workaround by creating a log.txt file marking the update progress as the script mines through the data making sure to terminate the program before the update limitation is reached, then automatically re-invoking the script and starting updates where it previously left off. Thanks for the help.