Help needed

Hi
I am using postgres 7.4.0. I have developed an application,
I am having a debtor table in which around 55 lacs of records are there. I have debtorid as a primary key. I am using like query to filter a data and display the data in the grid. When I am debugging an application it took comparatively less time to execute it and to display data. Where as after compiling it and creating an exe it's performance slow down drastically and took very long time to perform.

I will be really great full to you if you provide solution for the same

Thanks & regards,
Mahesh Shinde
------------------------------------------------------------------
Codec Communications (I) Pvt. Ltd.
PUNE (INDIA)
T # 91-20-24221460/70(Ext 43)
Desk No. 25143
Email - mahesh(dot)shinde(at)codecindia(dot)com