Hello,
I am a software developer working for Lntinfotech,
I am using Mysql-4.1.3b-beta-nt,ODBC3.5.1 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 nature
of data is records containing alarms and faults
occuring in the CDMA system,after storing the data we
need to generate statistical reports on these data
my table structure is as fallows,
CREATE TABLE IND_KAR_BNG_Metallica_PS_RT_4
(
gan_id INTEGER NOT NULL,
bsc_id INTEGER NOT NULL,
bts_id INTEGER NOT NULL,
bd_type VARCHAR(10) NOT NULL,
bd_id INTEGER NOT NULL,
duplex VARCHAR(10) NOT NULL,
data_GenTime DATETIME NOT NULL,
item_id INTEGER NOT NULL,
M0 INTEGER NOT NULL,
M1 INTEGER NOT NULL,
M2 INTEGER NOT NULL,
M3 INTEGER NOT NULL,
M4 INTEGER NOT NULL,
M5 INTEGER NOT NULL,
M6 INTEGER NOT NULL,
M7 INTEGER NOT NULL,
M8 INTEGER NOT NULL,
M9 INTEGER NOT NULL,
M10 INTEGER NOT NULL,
M11 INTEGER NOT NULL,
M12 INTEGER NOT NULL,
M13 INTEGER NOT NULL,
M14 INTEGER NOT NULL,
M15 INTEGER NOT NULL,
M16 INTEGER NOT NULL,
M17 INTEGER NOT NULL,
M18 INTEGER NOT NULL,
M19 INTEGER NOT NULL,
M20 INTEGER NOT NULL,
M21 INTEGER NOT NULL,
M22 INTEGER NOT NULL,
M23 INTEGER NOT NULL,
M24 INTEGER NOT NULL,
M25 INTEGER NOT NULL,
M26 INTEGER NOT NULL,
M27 INTEGER NOT NULL,
M28 INTEGER NOT NULL,
M29 INTEGER NOT NULL,
M30 INTEGER NOT NULL,
M31 INTEGER NOT NULL,
INDEX RetreiveIndex (data_GenTime,gan_id ,bsc_id
,bts_id ,bd_type ,bd_id ,item_id));
i am using ODBC3.5.1 for connection establishment to
the DB server through an application running on
windows 2000 PC
the problem i am facing:
initially application behaves fine till the record
count has reached to around 25 lakh records..
after this it is drastically getting slower as the
record count increases..
ie. query responce time is increasing as the record
count is increasing. this continues and the
application has problem in retreiving data faster..
please suggest a way to improve the query responce
time
with table stucture being maintained.I have alderdy
tried indexing few key columns as u can see in the
table structure.
hoping for u reply at the earliest,
thanking u,
chethan.
__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
