You have commented 375 times on Rantburg.

Your Name
Your e-mail (optional)
Website (optional)
My Original Nic        Pic-a-Nic        Sorry. Comments have been closed on this article.
Bold Italic Underline Strike Bullet Blockquote Small Big Link Squish Foto Photo
Submit your comments on this article
Today's tech notes...
2007-06-06
I'm in the process of migrating the comments from MySQL to Postgres, which is a more robust database. Right now we're making two copies of each comment, one to each database, while I copy the old comments a month at a time. Occasionally things will get out of synch, but I'm hoping they'll be brought back to where they're supposed to be when the process is done.

Once I've moved the comments, which is the largest table, I'll move the articles. When they've been moved, I'll shut down MySQL.

If Postgres isn't robust enough to handle the load -- which it should be -- I can always use Oracle. I'll just have to rewrite major chunks of my code, rather than the minor chunks I'm dealing with now.
Posted by:Fred

#25  comments); ?>werwer
Posted by: Fred   2007-06-06 22:03  

#24  comments); ?>werwer
Posted by: Grumenk Philalzabod0723   2007-06-06 19:09  

#23  comments); ?>werwer
Posted by: Barbara Skolaut   2007-06-06 18:13  

#22  comments); ?>werwer
Posted by: anonymous5089   2007-06-06 15:43  

#21  comments); ?>werwer
Posted by: anonymous5089   2007-06-06 15:43  

#20  comments); ?>werwer
Posted by: mojo   2007-06-06 15:37  

#19  comments); ?>werwer
Posted by: bombay   2007-06-06 13:44  

#18  comments); ?>werwer
Posted by: trailing wife   2007-06-06 12:06  

#17  comments); ?>werwer
Posted by: anonymous5089   2007-06-06 11:04  

#16  comments); ?>werwer
Posted by: anonymous5089   2007-06-06 11:02  

#15  comments); ?>werwer
Posted by: trailing wife   2007-06-06 11:01  

#14  comments); ?>werwer
Posted by: Seafarious   2007-06-06 10:54  

#13  comments); ?>werwer
Posted by: Fred   2007-06-06 10:26  

#12  comments); ?>werwer
Posted by: treo   2007-06-06 10:23  

#11  comments); ?>werwer
Posted by: anonymous5089   2007-06-06 09:03  

#10  comments); ?>werwer
Posted by: DarthVader   2007-06-06 08:08  

#9  comments); ?>werwer
Posted by: Dave D.   2007-06-06 07:26  

#8  comments); ?>werwer
Posted by: Fred   2007-06-06 07:04  

#7  comments); ?>werwer
Posted by: Bright Pebbles in Blairistan   2007-06-06 06:52  

#6  comments); ?>werwer
Posted by: Howard UK   2007-06-06 06:22  

#5  comments); ?>werwer
Posted by: Howard UK   2007-06-06 06:21  

#4  comments); ?>werwer
Posted by: Phineter Thraviger   2007-06-06 01:48  

#3  comments); ?>werwer
Posted by: Seafarious   2007-06-06 01:41  

#2  comments); ?>werwer
Posted by: RD    2007-06-06 01:02  

#1  comments); ?>werwer
Posted by: Jan   2007-06-06 00:41  

00:00