🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: be.comp.programming
Article #4082

Re: SQL vraag

#4082
From: Ramon Smits
Date: Sun, 21 Sep 2003 21:31
16 lines
1622 bytes
HomeAutomation Freak wrote:

> Hmm, het is een tabel met een paar honderdduizend records,
> zo wordt m'n database ineens weer wat MB's meer h� ;-)

Ja, maar de betreffende kolom is opeens wel index friendly! Ff een non 
unique index en het gaat als de brandweer!


M.v.g.,
Ramon


--
Ramon Smits aka. Exyll
http://www.exyll.net/ (ipv6 enabled)
Technical Details
Message-ID: <3f6e1892$0$59347$e4fe514c@dreader8.news.xs4all.nl>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!transit.news.xs4all.nl!newsfeed.xs4all.nl!xs4all!rhinewceros.xs4all.nl!not-for-mail
References: <4m5rmvsgv80sb2u1gn1f89tp4u1qabag92@4ax.com> <an8rmv0upnljin6hdqp0mvg2anmlgsbed4@news.xs4all.nl> <nnarmv043tfb2no3tibs6dt344mqithhmd@4ax.com>

Show Full Headers
Complete Article Headers
X-Google-Language: DUTCH,ASCII
X-Google-Thread: 107324,64c4e42a30cef025
X-Google-Attributes: gid107324,public
X-Google-Thread: fcea4,64c4e42a30cef025
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2003-09-21 14:31:09 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!transit.news.xs4all.nl!newsfeed.xs4all.nl!xs4all!rhinewceros.xs4all.nl!not-for-mail
Date: Sun, 21 Sep 2003 23:31:00 +0200
From: Ramon Smits <exyll@hotmail.com>
Organization: Subliminal
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5b) Gecko/20030901 Thunderbird/0.2
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: be.comp.programming,nl.comp.programmeren
Subject: Re: SQL vraag
References: <4m5rmvsgv80sb2u1gn1f89tp4u1qabag92@4ax.com> <an8rmv0upnljin6hdqp0mvg2anmlgsbed4@news.xs4all.nl> <nnarmv043tfb2no3tibs6dt344mqithhmd@4ax.com>
In-Reply-To: <nnarmv043tfb2no3tibs6dt344mqithhmd@4ax.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Lines: 17
Message-ID: <3f6e1892$0$59347$e4fe514c@dreader8.news.xs4all.nl>
NNTP-Posting-Host: 194.109.160.204
X-Trace: 1064179859 dreader8.news.xs4all.nl 59347 194.109.160.204:32180