Re: Hurtigste databaseprodukt

Article View: dk.edb.database

Article #15327

#15327

From: Lauritz Jensen
Date: Mon, 21 May 2001 14:20

15 lines
1586 bytes

Anders Johannsen wrote:
> 
> Tabellen er kun 5-6 felter 'bred' -- og det felt jeg �nsker at 
> s�ge p� er i det h�jeste 250 tegn langt. Det jeg s�ger at opn�, 
> er basalt nedenst�ende:
> 
>     SELECT id, field FROM table WHERE field LIKE '%query%'

Det lugter lidt af en friteksts�gning. Hvis det er det, hvorfor s� ikke
bare lave et index, der kan klare det? Sagt p� en anden m�de: Hvis du
laver dine forsp�rgsler med hovedet under armen, s� kan du f� en hver
database i kn�.

-- 
Lauritz

Technical Details

Message-ID: <3B092415.6C1FE9E6@hotmail.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!news010.worldonline.dk.POSTED!not-for-mail

References: <9eb404$t88$1@news.inet.tele.dk> <CQ8O6.168$7l3.7540@news.get2net.dk> <9eb70e$9vc$1@news.inet.tele.dk>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,37b2a7d741ebbb54
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-05-21 07:19:49 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!news010.worldonline.dk.POSTED!not-for-mail
Message-ID: <3B092415.6C1FE9E6@hotmail.com>
From: Lauritz Jensen <lauritz2@hotmail.com>
Organization: -
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: dk.edb.database
Subject: Re: Hurtigste databaseprodukt
References: <9eb404$t88$1@news.inet.tele.dk> <CQ8O6.168$7l3.7540@news.get2net.dk> <9eb70e$9vc$1@news.inet.tele.dk>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Lines: 15
Date: Mon, 21 May 2001 16:20:05 +0200
NNTP-Posting-Host: 213.237.43.17
X-Complaints-To: news-abuse@wol.dk
X-Trace: news010.worldonline.dk 990454788 213.237.43.17 (Mon, 21 May 2001 16:19:48 MET DST)
NNTP-Posting-Date: Mon, 21 May 2001 16:19:48 MET DST

Reply to Parent Message