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
Forgot to mention maintaining an index on the orf column in each table to speed
up the order by, and running VACUUM ANALYZE on a table any time it changes
substantially, or at appropriate intervals. Is it possible to make orf an
integer if it isn't already? Remember that the index will slow do