Thread: Test data sets
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
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
> > 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
> -------------------------------------------------------------------------
>
>
>
>
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
-------------------------------------------------------------------------