VB Postgres connection problem

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. Where as 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.