Oninit cdi / Archive
Talk to an expert →

DBI query to Informix takes 20sec to end

Posted in 2003

Topics: Stored Procedures & SPL, Platform-Specific Issues

Thomas — — source: Usenet: comp.databases.informix

I used Perl DBI to access Informix IDS 2000 on Solaris 2.8. The query is a simple SELECT and it gets data from Informix pretty quick. However it takes up to 20s for the prompt to show up after all data is displayed, sometime it is quick though. I don't see anything else wrong other than the long wait. My database is logged. Thanks a lot,

↪ replying to Thomas
Bob Mariotti — — source: Usenet: comp.databases.informix

On 27 May 2003 15:28:40 -0700, cfa532@hotmail.com (Thomas) wrote: >I used Perl DBI to access Informix IDS 2000 on Solaris 2.8. The query >is a simple SELECT and it gets data from Informix pretty quick. >However it takes up to 20s for the prompt to show up after all data is >displayed, sometime it is quick though. I don't see anything else >wrong other than the long wait. My database is logged. > >Thanks a lot, If you're selecting on an indexed field then carefully check your syntax of the select statement and the field(s) you are selecting on. If they're NOT quoted properly I've found that perl will change the field type which can cause a sequential search of the ENTIRE DB. Bob

Related threads

Glossary