Thread: Help needed

Help needed

From

"Mahesh Shinde"

Date:

04 August 2005, 19:53:39

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.shinde@codecindia.com

Re: Help needed

From

Dave Cramer

Date:

04 August 2005, 20:02:34

Mahesh,

We would love to help you,but this is a very vague question. Can you verify that the problem is in the driver/postgres ?

put debug messages, with timing around your code

Dave

On 4-Aug-05, at 9:46 AM, Mahesh Shinde wrote:

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.shinde@codecindia.com