>>I am looking for a really big data file to use in a VFP demo. I wanted something with a few hundred thousand records, like street names or postal codes or something like that I could run queries on both using DBF files and also with the data transfered to SQL Server. If someone has a file they'd like to share, or a routine that builds a big file (a few hundred megs, a few million records!) I would appreciate it.
>>
>>Or if you can point me to somewhere on the web where i can grab a big text file I can convert into to DBF that would be useful too.
>
>Just build a routine that loops and appends records into a file.
>
>CREATE CURSOR myCursor (cfield C(10), nfield i)
>FOR i = 1 TO 1000000
>INSERT INTO myCursor Values (SYS(2015), i)
>ENDFOR
>
>You could get as creative as you want with random values.
I took your advice and built a big table myself. I used an address table that had 1200 records and a name table that had 1000 records and created 1,000,000 records in a table that randomly chose the first name, the last name and the address and put them together. The table is 171 MB. I might double it depending on how the demo goes.
Part of my demo is comparing VFP web access (using Web Connection) to ASP. We have a page in our current system that takes 7 seconds to retrieve a list of records. I wrote the same function in VFP running against the same data in SQL Server. It takes about 1.5 seconds. About 1 second of that is the time the browser takes to display the info.
I may move the table to SQL Server to compare performance.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only