Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Fails in VFP v9.0
Message
 
 
To
22/06/2006 10:11:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01130572
Message ID:
01130816
Views:
28
Tamar,

>I actually have one thing I'm working on that has a RandomRecord method. I've been fiddling around with a class to generate test data.

We were doing a load test on a new system here and needed to generate 10 million name and address records that had "statistically valid" distributions for name and address information to make sure index fragmentation would be the same as it would be when the system went into production. I used real data from another couple of systems to create probability distributions for elements like first name, lastname, address, city, state and zipcode. These distributions were used to then generate "realistic" random data.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform