Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bernard Bout
  Where is Bernard Bout?
 Brisbane
 Australia
 Bernard Bout
 To: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Netherlands
 Boudewijn Lutgerink
 Tags
Subject: RE: need a substantial database??
Thread ID: 143503 Message ID: 143590 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, August 30, 2007 5:55:27 AM         
   


> 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".

Has anyone succeeded in D/l this file?

I get to the FTP page ok but it does not allow me to download. I tried both IE and Foxfire.

Bernard

** If you see someone without a smile, give em one of yours :) **

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