Newsgroups: comp.databases.theory Subject: Re: Database naming convention (yet another post of it, but a bit different) From: Pablo Sanchez References: <3e55b51a.0210081559.4ac4c1f9@posting.google.com> Message-ID: User-Agent: Xnews/5.04.25 NNTP-Posting-Host: newsfeeds2 Date: 10 Oct 2002 07:29:05 -0500 Lines: 20 X-Authenticated-User: $$yl_vltqb X-Comments: This message was posted through Newsfeeds.com X-Comments2: IMPORTANT: Newsfeeds.com does not condone, nor support, spam or any illegal or copyrighted postings. X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!! X-Report: Please report illegal or inappropriate use to You may also use our online abuse reporting from: http://www.newsfeeds.com/abuseform.htm X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body (DO NOT SEND ATTACHMENTS) Organization: Newsfeeds.com http://www.newsfeeds.com 100,000+ UNCENSORED Newsgroups. Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed-east.nntpserver.com!nntpserver.com!news-out.visi.com!hermes.visi.com!128.242.126.79.MISMATCH!l-out.nntp.be!corp-news.newsgroups.com!not-for-mail Xref: newsfeed1.easynews.com comp.databases.theory:22912 X-Received-Date: Thu, 10 Oct 2002 05:34:32 MST (news.easynews.com) "stu" wrote in news:ao3ep1$4rd$2$8302bc10@news.demon.co.uk: >>Especially when it comes to cases where >> we have a table with one row. > > Slightly OT but... > Are 1 row tables a good idea for storing settings? I usually set > up the following table(s) to store settings in a database: Stu, For sys_config values, I don't mind doing an ALTER TABLE. Especially if the underlying stored procedure that the front-end calls issues a 'select *' and binds at stored procedure compile time. No front-end is needed in order to install config data. -- Pablo Sanchez, High-Performance Database Engineering http://www.hpdbe.com