Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Netherlands
 Boudewijn Lutgerink
 Tags
Subject: RE: need a substantial database??
Thread ID: 143503 Message ID: 143513 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, August 29, 2007 1:22:10 PM         
   


> Hi all,
>
> having a database like Northwind is nice... as long as you need to learn the concepts of developing in VFP and the concept of relational databases.
> But it is rather useless if you want to take a look at speed....
>
> I developed therefore a northwind alike database but with (ahem) slighty more records.
> Here it goes:
> Addresses (like the customer table in NW) 150,000 faked names and addresses.
> These fakenames have fake accounts at a bank, total of 539,574 accounts of 4 different kinds. (See Accounttypes table)
> There are also 5 regions where these faked ppl live.
> (east west, south, north, middle) OK OK I know, my fantasy goes sky high.
> 15 employees, as in NW. I did not feel the need to work on that one. Who wants more, feel free to add so.
>
> Then orders, 672,039 orders with 3,089,749 orderlines.
>
> Of course these ppl need insurance. So I created a table for that 315,331 policies in that, of 4 types
> And while these ppl have a bankaccount (even though faked) I have "some" transactions on those accounts.
> 28,633,109 to be exact.
>
> This database can be used for your own purposes and will be available as-is. I will not take responsibility for resemblance of real people all data is fiction.
>
> How to download it:
> ftp to 212.29.188.133, port 21
> username and PW: vfpuser
>
> You can only "read" in that folder.
> I zipped the stuff. still 410 MB, So it might need some time.
> You can make one connection form any ip address only. There are 10 connections allowed simultanious.
> So if you cannot get in, try at a later time again.
>
> Enjoy,
>
> Boudewijn LutgeĀ®ink
> http://www.vfpdevelopers-online.com
> Border Collies, the only breed "That'll do".

Boudewijn,

This is a highly useful tool for those who do not have access to a large DB. Testing a class/procedure/etc against a large DB will allow the develper to work with that class/proc/etc. and optimize it. I can appreciate the amout of work it took to create that DB and I am grateful that you would be willing to share it. My rating to you sir.

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

ENTIRE THREAD

need a substantial database?? Posted by Boudewijn Lutgerink @ 8/29/2007 12:23:58 PM
RE: need a substantial database?? Posted by Ken Murphy @ 8/29/2007 1:22:10 PM
RE: need a substantial database?? Posted by Cetin Basoz @ 8/29/2007 1:24:09 PM
RE: need a substantial database?? Posted by Cetin Basoz @ 8/29/2007 1:30:26 PM
RE: need a substantial database?? Posted by Ken Murphy @ 8/29/2007 3:54:51 PM
RE: need a substantial database?? Posted by Aldrin Austria @ 8/29/2007 3:47:13 PM
RE: need a substantial database?? Posted by Boudewijn Lutgerink @ 8/29/2007 10:43:28 PM
RE: need a substantial database?? Posted by Ken Murphy @ 8/29/2007 11:13:03 PM
RE: need a substantial database?? Posted by Aldrin Austria @ 8/30/2007 4:37:49 PM
RE: need a substantial database?? Posted by Bernard Bout @ 8/30/2007 5:55:27 AM
RE: need a substantial database?? Posted by Cetin Basoz @ 8/30/2007 2:27:00 PM
RE: need a substantial database?? Posted by Bernard Bout @ 8/31/2007 8:55:13 AM
RE: need a substantial database?? Posted by Boudewijn Lutgerink @ 8/31/2007 11:22:39 AM