>>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement