Your problem is your database structure. Instead of putting things into
500 tables, you should merge them into 1 table.
This is not a perl question, its a database design question.
-alex
On Mon, 13 Aug 2001, Evan Zane Macosko wrote:
> Hi everyone,
>
>
> I am use Perl:DBI to interface to a Po
slow down inserts and
updates, so weigh the tradeoff.
Evan Zane Macosko <[EMAIL PROTECTED]> on 08/13/2001
05:04:50 PM
To: [EMAIL PROTECTED]
cc:(bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: Optimizing Postgres selects
Hi everyone,
I am use Perl:DBI to interface to a Postgres da
Hi everyone,
I am use Perl:DBI to interface to a Postgres database that contains many
tables with two columns and about 6000 rows. Inside my perl program, i
need to select one column from each of these 500 tables--as many as 500 at
once--and the way I'm doing it, it seems to take a lot of time
