Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Base Tables
Message
From
20/12/2017 13:29:57
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01656587
Message ID:
01656595
Views:
55
>
>You can probably send several commands at once and use multiple result sets (say, do 10 tables in one command).

For 300+ tables ? Even if all are maximum vfp dbf+dbt capacity, that is below 1.3 TB. There will be a bottleneck somewhere, but not doing it 1 by one will not eliminate that, only add to needed checking - dunno if it might introduce even more overhead at the disk physical level. Race condition would be to harsh, but moving off best sequential read positions, if SQL is not on SSD but traditional RAID....

Run a simple count (*) first to see all tables are responding, save results to compare after moving to vfp and fire off. KISS
Previous
Reply
Map
View

Click here to load this message in the networking platform