Re: speed up query
currently the table size is 4.3 gb
4.7G -rw-rw---- 1 mysql mysql 4.7G May 1 13:17 ibdata1
you have given a very good idea but the customer support fetchs too many records from dsl_data on (id index, which is fast) thats why i should move them to dsl_data but as far as reports are concerned it all depends on manaaagment for how many days or how much time do they want the query for, thats why i m more concentrating on this table to be optimized and this is the only large table others are not much, till now i normally move data to temp table from this table to make it happy. i should also be concern about the table file size as it ll grow rapidly, and if i can place it on different hard drives to improve performance.
Subject
Views
Written By
Posted
4144
April 18, 2010 06:42AM
1512
April 18, 2010 04:04PM
1592
April 18, 2010 05:40PM
1317
April 27, 2010 02:29PM
1464
April 27, 2010 07:59PM
1321
April 28, 2010 12:12AM
1581
April 28, 2010 06:22AM
1524
April 29, 2010 01:03AM
1379
April 29, 2010 02:17AM
1384
April 29, 2010 08:19AM
1386
April 29, 2010 09:18AM
1315
April 30, 2010 12:30AM
1570
April 30, 2010 07:47AM
1487
April 30, 2010 08:21AM
1399
April 30, 2010 10:08AM
Re: speed up query
1320
May 01, 2010 02:34AM
1337
May 01, 2010 09:54AM
1289
May 01, 2010 10:48AM
1418
May 01, 2010 02:20PM
1357
May 02, 2010 03:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.