Article View: dk.edb.database
Article #15298Re: Databaseydelse / optimering
From: Morten Winther
Date: Fri, 08 Jun 2001 22:06
Date: Fri, 08 Jun 2001 22:06
11 lines
1497 bytes
1497 bytes
"Christian Flintrup" <junk@osxhacks.com> wrote in message news:1eumw5n.xz7ur51uj3f2iN%junk@osxhacks.com... > Hvis man har et chatsystem med >1000 registerede brugere hvoraf ca 20 > normalt er koblet p� samtidigt, og det er begyndt at g� lidt langsomt, > hvad kan man s� g�re for at optimere databasen? > > Det er MySQL. Se evt www.netverden.dk for at se hvad jeg mener. Test om jeres SELECT's er gode via EXPLAIN. / morten
Technical Details
Message-ID:
<9fri51$nun$1@news.inet.tele.dk>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.icl.net!newsfeed00.sul.t-online.de!t-online.de!news.tele.dk!TDC-Europe.POSTED!ip706.boanxx7.adsl.tele.dk!not-for-mailReferences:
<1eumw5n.xz7ur51uj3f2iN%junk@osxhacks.com>Show Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII X-Google-Thread: fcdf9,2374690f8a0f3878 X-Google-Attributes: gidfcdf9,public X-Google-ArrivalTime: 2001-06-08 15:04:19 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.icl.net!newsfeed00.sul.t-online.de!t-online.de!news.tele.dk!TDC-Europe.POSTED!ip706.boanxx7.adsl.tele.dk!not-for-mail From: "Morten Winther" <mw@get2net.dk> Newsgroups: dk.edb.database Subject: Re: Databaseydelse / optimering Date: Sat, 9 Jun 2001 00:06:58 +0200 Organization: Posted through some European Outpost of TDC Internet A/S Lines: 14 Message-ID: <9fri51$nun$1@news.inet.tele.dk> References: <1eumw5n.xz7ur51uj3f2iN%junk@osxhacks.com> NNTP-Posting-Host: ip706.boanxx7.adsl.tele.dk X-Trace: news.inet.tele.dk 992037857 24535 62.243.129.198 X-Complaints-To: the appropriate department of the poster's provider X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700