in reply to Re^3: I got confuse with INSERT
in thread I got confuse with INSERT
yes is like this:
We have a very obsolete program that runs on FoxPro for DOS
but for a big reason ($$$$) we cant change it, our customers
want to see the data send to us in a more easy way like a web page
so I need to take the data from several DBF and turn them into MySQL tables to work with them the thing is that in the convertion is taking a lot of time, and the clients wants to see them in real time
working with mysql is quite fast but when I need to do the part of bringing new data from dbf to mysql it take sometime like 7 minutes for one table (a small one) so imagine a big table with almost 3 times that size it takes forever.
So I try to do it directly with DBF but it takes more time.
We have a very obsolete program that runs on FoxPro for DOS
but for a big reason ($$$$) we cant change it, our customers
want to see the data send to us in a more easy way like a web page
so I need to take the data from several DBF and turn them into MySQL tables to work with them the thing is that in the convertion is taking a lot of time, and the clients wants to see them in real time
working with mysql is quite fast but when I need to do the part of bringing new data from dbf to mysql it take sometime like 7 minutes for one table (a small one) so imagine a big table with almost 3 times that size it takes forever.
So I try to do it directly with DBF but it takes more time.
In Section
Seekers of Perl Wisdom