Re: Partitioning help
Thanks Rick for your response. We have blade server with Fiber channel san attached to it. They are looking at approximately 1000 inserts/hour with HTML data being zipped and inserted. The message is queued to a JMS queue and being inserted to the db (sorry I don't understand that very well). Think it can be batched up. The requirement is that the inserts should take less than 0.05 seconds. The data is more of a logging data where it is required to be stored for a while(2 weeks for now) and then deleted. I have not created a database or tables yet so don't have the table structure. But the table needs to have a id column which is unique and inserted from the application where I need to have a index on it. There is one more column "type" which is used to identify the type of requests if it's one of A , F, C. So I want to have 3 tables partitioned by day and type so that I can drop the old partitions when I don't need it. Disk space is not a constraint. The data is not very sensitive so backups are not required. writes are more important factor of the db and they should be able to read the data as well without blocking writes.
Could you suggest me the best way for partitioning the data? Also I would like to know if myIsam would be reliable and can store that quantity of data?
Please let me know if something is not clear
thank you very much..
Subject
Views
Written By
Posted
3329
September 24, 2010 02:16AM
1791
September 25, 2010 01:09PM
Re: Partitioning help
1755
September 27, 2010 03:43AM
1733
September 27, 2010 07:55PM
1700
October 12, 2010 01:55AM
1680
October 12, 2010 08:03AM
1593
October 13, 2010 03:27AM
1628
October 13, 2010 06:03PM
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.