I think I need to study Database Tuning later... when I have time.
Recently I'm doing a Data Conversion project.
There are around 1.x million history records storing in 70+ VFP tables (1 table for each month).
I've made a looping package (it's new, great job M$!) to import such tables.
But the performance of the package is just bullshit.
Well, I guess the bottleneck is on VFP side (maybe VFP OleDB Provider, or File I/O of such VFP files (.dbf, .fpt ...).
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment