Home » RDBMS Server » Performance Tuning » Dirty database_Performance issues
Dirty database_Performance issues [message #357109] Tue, 04 November 2008 00:03 Go to next message
neena_forum
Messages: 1
Registered: November 2008
Junior Member
Hi all
i have the followong situaton
 After the many insert, update, and delete operation, the physical address on the disk drive many not be continuous one for some record.

this may affect the performance.
Can anyone help me to resolve this?
Is there any solution for this?
Re: Dirty database_Performance issues [message #357123 is a reply to message #357109] Tue, 04 November 2008 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It does not matter. In modern system with disk array and RAID technology, you never know where data are on disk and most often they are never contiguous.

Regards
Michel
Re: Dirty database_Performance issues [message #357316 is a reply to message #357123] Tue, 04 November 2008 19:36 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Still though, there are benefits to be had from placing rows commonly accessed together in the same database block.

This can be done using a CLUSTER. This is not so popular any more, not least because it means more work for DBAs.

The other way is to rebuild your table periodically:
CREATE TABLE new_table AS
SELECT * 
FROM old_table
ORDER BY this_col


Depending on your situation - and the problem you are trying to solve - this may work great or not at all.

Ross Leishman
Previous Topic: Purgeing data
Next Topic: Index a system view
Goto Forum:
  


Current Time: Thu Dec 08 22:09:24 CST 2016

Total time taken to generate the page: 0.11340 seconds