Data Partitioning with Informix Dynamic Server Print E-mail
Spread the news
Delicious
Furl it!
Spurl
NewsVine
Reddit
YahooMyWeb
Technorati
Digg
User Rating: / 0
PoorBest 
Written by Robby Ivanovitch   
Thursday, 23 October 2008
(Andrew Ford) One of the engines that I manage contains a particularily nasty table. Let me know if this sounds familiar: This troublemaker is a history table that stores the details of each of the 2 million transactions our platform processes each day. The rows are wide, weighing in at over 900 bytes per row, letting me fit a whopping 2 rows per 2K page. The table contains the most recent six months of history; anything older than six months must be removed nightly to make room for tomorrow's d

 

 

Copyright © 2008. All rights reserved.




Discuss this article on the forums. (0 posts)


 
< Prev   Next >
Community
Popular Blogs
All Blogs
Community Forum
Main Menu
Home
Forum
Directory
Links
Search
Newsflash
InformixTechDay in Strasbourg (the Capital of Europe)
Read more...
 
Insider - November 2008
Read more...
 
Ads
Login Form





Lost Password?
No account yet? Register