InvestorsHub Logo
Followers 44
Posts 3971
Boards Moderated 1
Alias Born 06/27/2005

Re: ToddWH02 post# 42884

Sunday, 01/14/2007 6:25:37 PM

Sunday, January 14, 2007 6:25:37 PM

Post# of 82841
Todd... It was simply a matter of Pinksheets doing maintenance on the back-end or databases. Pinksheets holds a lot of data in an Oracle back-end with a java interphase. Anytime you have a database, you must periodically take the database down to rebuild indexes, and possibly reorder tables if data structure changes have been implemented. Over time, a database will "abends" and will then create a new index for the the data. The more this happens, the less efficient the data retrieval becomes. This is why they have to perform periodic maintenance on the DBs. Ihub does basically the same thing. You can update a database in realtime without limiting access and therefore, it makes no sense that they would remove the old to update it with the new. It would be possible if they ran redundant databases but this can get costly. A decent Database administrator will get $60K - $150K a year. The bottom line is there was absolutely no reason to believe Pinksheets maintenance was/is tied to a single record in a database such as CKYS or any other company. When maintenance is performed, it's performed on the database, not individual records. My first guess is that they had to rebuild the indexes on the database.
RedCloud
Join InvestorsHub

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.