Re: DBD::Oracle dbd_st_execute slow speed

[email protected] (Mike Towery) Thu, 09 Dec 2010 09:52:22 -0600

Newsgroups	perl.dbi.users
Message-ID	<[email protected]>

Confirm that there are supporting indexes on the table columns that the 
FKs reference.  If not, that can definitely slow down your inserts as 
the tables grow larger.

There should be indexes on:
MJMC.ABI_FL_SYS_FMT (ABI_FMT_ID)
MJMC.NDE_DATA_HIST (DATA_COLL_ID)


Regards,
Mike Towery

lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.