Test data sets

Sure try this one

#!/bin/perl

for ( my $i = 0 ; $i < 100000000; $i++)
{
$buf = sprintf("John-%d:addr-%d:whatever-%d\n", $i);
print $buf;
}

save the output to a file and slurp it in

Or if you want, write a DBI code that does 10000000 inserts.

tsmets@brutele.be wrote:

I was wandering were I could find data sets to test some of the behavior of
my DB.
I basically need a few thousands records of address like data ...
May be pumping it from the on-line telephone guides is an option but ... is
there smthg available as such on the net ?

Tx,

thomas,

--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id : smetsthomas

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
-------------------------------------------------------------------------
Medi Montaseri medi@CyberShell.com
Unix Distributed Systems Engineer HTTP://www.CyberShell.com
CyberShell Engineering
-------------------------------------------------------------------------

Tx,
I did my own Java garbage generator ...
I was looking for a closer to real life set.
U know one of these big company that just mixed up all the addresses / zip
code & town accross countries, hence you have it very hard ot find it back
anybody.

Way much harder than looking on the internet to find him / her !

thomas,

--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id : smetsthomas
----- Original Message -----
From: "Medi Montaseri" <medi@cybershell.com>
To: <tsmets@brutele.be>
Cc: <pgsql-general@postgresql.org>
Sent: 27 March, 2002 8:06 AM
Subject: Re: [GENERAL] Test data sets

Sure try this one

#!/bin/perl

for ( my $i = 0 ; $i < 100000000; $i++)
{
$buf = sprintf("John-%d:addr-%d:whatever-%d\n", $i);
print $buf;
}

save the output to a file and slurp it in

Or if you want, write a DBI code that does 10000000 inserts.

tsmets@brutele.be wrote:

I was wandering were I could find data sets to test some of the behavior

of

my DB.
I basically need a few thousands records of address like data ...
May be pumping it from the on-line telephone guides is an option but ...

is

The database tables don't care if they are John Doe or John Smith....
I personally would object to any internet site who would make to assist with
making people's addresses or information available, be it for testing a
database
or a tool for yet another spammer....

On the technical side, working with a set of known data is much easier to
profile a system than with random data...

tsmets@brutele.be wrote:

Tx,
I did my own Java garbage generator ...
I was looking for a closer to real life set.
U know one of these big company that just mixed up all the addresses / zip
code & town accross countries, hence you have it very hard ot find it back
anybody.

Way much harder than looking on the internet to find him / her !

thomas,

--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id : smetsthomas
----- Original Message -----
From: "Medi Montaseri" <medi@cybershell.com>
To: <tsmets@brutele.be>
Cc: <pgsql-general@postgresql.org>
Sent: 27 March, 2002 8:06 AM
Subject: Re: [GENERAL] Test data sets

Sure try this one

#!/bin/perl

for ( my $i = 0 ; $i < 100000000; $i++)
{
$buf = sprintf("John-%d:addr-%d:whatever-%d\n", $i);
print $buf;
}

save the output to a file and slurp it in

Or if you want, write a DBI code that does 10000000 inserts.

tsmets@brutele.be wrote:

I was wandering were I could find data sets to test some of the behavior

of

my DB.
I basically need a few thousands records of address like data ...
May be pumping it from the on-line telephone guides is an option but ...

is

there smthg available as such on the net ?

Tx,

thomas,

--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id : smetsthomas

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
-------------------------------------------------------------------------
Medi Montaseri medi@CyberShell.com
Unix Distributed Systems Engineer HTTP://www.CyberShell.com
CyberShell Engineering
-------------------------------------------------------------------------

--
-------------------------------------------------------------------------
Medi Montaseri medi@CyberShell.com
Unix Distributed Systems Engineer HTTP://www.CyberShell.com
CyberShell Engineering
-------------------------------------------------------------------------