Re: How to reduce the query response time?

2004-12-08 Thread SGreen
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 bts_id = 255 and data_Gentime between "2004-11-22 00:00:00" and "2004-12-10 19:41:44" and item_id = 0; If you frequently query on bsc_i

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 nat