SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
SI - Site Forums : Silicon Investor - Legacy Interface Discussion (2004-2011)
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: SI Dave who wrote (2861)12/9/2004 11:48:07 AM
From: SI Bob  Read Replies (1) of 6035
 
I'm content with the session I'm currently using, so go ahead and close whatever you want in the other one.

The off-site backup is happening right now and supposedly has a day and a half left to go. While that's happening, I'm doing a lot of trimming down in the production database. Any tables I'm deleting, I'm first moving them to the deleted data backup db.

I deleted what I think (hope) are unnnecessary fields from the 1997 and earlier search table. Could you check for me and make sure searches still work correctly for that table? If so, I'll duplicate the field deletions on the remaining search tables.

I could actually get rid of all fields but the messageid and message text fields and use a join to the real message table to get the rest of the data that's needed. But will test that scenario to see if there's any kind of performance or overhead penalty before actually doing that. If there's a penalty, I'll leave the other fields intact since I'm trying to cut down on space the db is using but don't need to get too extreme about it.

Anyway, that's my current project. Cleanup and trimming. Tonight we're likely to have some periods where the site is getting timeouts from the db because I'll be shrinking the db, which is an expensive process.
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2026 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News