Article View: dk.edb.database
Article #15320Re: [MySQL] Hvor mange felter???
From: Kristian Damm Jensen
Date: Thu, 17 May 2001 06:24
Date: Thu, 17 May 2001 06:24
24 lines
2150 bytes
2150 bytes
"Stig N�rgaard Jepsen" wrote: <snip> > Men stadigv�k er jeg interesseret i performancen... alts� forskellen i at > ha' 25 og 50 kolonner... Nuvel, de fleste performance-problemer kan l�ses ved et index p� de rette kolonner. Dog kan basen f� problemer uanset index, hvis den enkelte record er st�rre end en dataside. Det handler alts� ikke som s�dan om antallet af kolonner, men om hvor meget de fylder tilsammen. 50 integers � 4 byte = 200 byte er intet problem. 50 char(255) = 25Kbyte vil h�jst sandsynligt give et problem. Bortset fra det, s� lyder det umiddelbart som om du er ved at lave noget med en d�rlig struktur. Jeg har aldrig f�r set en tabel med s� mange felter (som var en del af et velstruktureret system). -- Kristian Damm Jensen | Feed the hungry. Go to kristian-damm.jensen@capgemini.dk | http://www.thehungersite.com
Technical Details
Message-ID:
<3B036EB6.D9C33860@REMOVEcapgemini.dk>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out-sjo.usenetserver.com!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!not-for-mailReferences:
<9drsu8$5t1$1@news.inet.tele.dk> <3B017BCA.2D8ED85E@hotmail.com> <9ds8gb$dn5$1@news.inet.tele.dk>Show Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII X-Google-Thread: fcdf9,34d5627aa5f1a28f X-Google-Attributes: gidfcdf9,public X-Google-ArrivalTime: 2001-05-20 21:32:04 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out-sjo.usenetserver.com!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!not-for-mail From: Kristian Damm Jensen <kristian-Damm.Jensen@REMOVEcapgemini.dk> Newsgroups: dk.edb.database Subject: Re: [MySQL] Hvor mange felter??? Date: Thu, 17 May 2001 08:24:54 +0200 Organization: CAP Gemini Danmark A/S Lines: 26 Sender: kristian-damm.jensen@capgemini1.capgemini.se Message-ID: <3B036EB6.D9C33860@REMOVEcapgemini.dk> References: <9drsu8$5t1$1@news.inet.tele.dk> <3B017BCA.2D8ED85E@hotmail.com> <9ds8gb$dn5$1@news.inet.tele.dk> NNTP-Posting-Host: capgemini1.capgemini.se Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Trace: sunsite.dk 990419402 26362 193.234.247.10 (21 May 2001 04:30:02 GMT) X-Complaints-To: news@sunsite.dk NNTP-Posting-Date: Mon, 21 May 2001 04:30:02 +0000 (UTC) X-Mailer: Mozilla 4.72 [en] (WinNT; I) X-Accept-Language: en,da X-Authenticated: kristian-damm.jensen@capgemini.dk