[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

Re: [PROGRAMMERING] MySQL begrænset SELECT



On Thu, 12 Aug 2004 23:15:44 +0200
Peter Maersk-Moller <sslug@sslug> wrote:

> Hej
> 
> I takt med at ens database vokser, vil det være rart om man
> kan begrænse load på db-serveren i forbindelse med returnering
> af søgeresultatet.
> 
> Jeg antager at søgningen tager den tid og load det kræver, men
> når resultatet returneres (her bruger jeg dels DBI - perl og dels
> PAI'et til C) allokeres der ressourcer til at returnere hele
> resultatet - tror jeg
> 
> Antag, at jeg har en db-table med 100, 1000 eller 1000000 rækker.
> Når jeg nu søger, ønsker jeg f.eks. kun at få vist N rækker af
> gangen, da jeg alligevel ikke praktisk kan vise en million
> linjer på en webside.
> 
> kan man gøre noget i stil med
> 
>    SELECT * FROM db-table START=50 END=99;
> 
> som så skulle returnere række 50 til række 99 ?
> 
> Det hedder nok ikke START og END, man kan man opnå det
> ønskede på en eller anden måde og betyder det noget for
> dan samlede load ?
> 


det hedder LIMIT

SELECT foo,bar FROM db-table LIMIT OFFSET,AMOUNT

f.eks. 
SELECT foo,bar FROM db-table LIMIT 50,49

tager fra række 50 og så 49 rækker frem. 

MVH
Kim 


 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2005-08-10, 22:44 CEST [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *