Обсуждение: Help needed

Поиск
Список
Период
Сортировка

Help needed

От
"Mahesh Shinde"
Дата:
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

Re: Help needed

От
Dave Cramer
Дата:
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