Re: How to reduce the query response time?

2004-12-08 Thread SGreen
note: this is this message's second sending after some snippage to meet the 3 character limit for the list and other mild editing.-- SG This is the query you would like to optimize: select Sum(m0),Avg(m1),Max(m5),Min(m6) from ind_kar_bng_robocop_bsc_0_pm_ipc_0 where bsc_id = 0 and

How to reduce the query response time?

2004-12-06 Thread chetan t
Hello, I am a software developer, I am using Mysql-4.1.3b-beta-nt, ODBC3.5.1 driver on windows PC for an application development. the application which i am developing is a client-server architecture based,in which we have to store data of the BSM(Base Station Manager of CDMA network). the