Getting selected rows out of an access database

[badLarry]

I'm currently using this code to output my blog entries. The problem i'm having
is getting all the information from the database everytime is slowing down the
server a little. Is there a way to only get 10 entries at a time from the
database, and incrementing that through <cfquery> instead of <cfoutput>?




<cfquery name="blogEntry" datasource="#request.dsn#">
SELECT *
FROM entry
ORDER BY entryID DESC
</cfquery>

<cfoutput query="blogEntry" maxrows="10" startrow="#url.startrow#">
**formatting**
</cfoutput>

[MikerRoo]

If the query data does not change much, cache the query.

Two things that can make an immediate impact:
Don't use "SELECT *"! List only the columns that are needed, this can save
quite a bit of time and memory.
Use TOP in the query itself to limit the actual data.
For example:
Set iLastRow = StartRow + maxrows
Then, use:
SELECT TOP #iLastRow#
Column A, Column B, Column C, etc.
FROM entry ... ...


There are ways to limit Access to just the 10 records desired but they require
redesigning the actual query somewhat (Use "TOP" and self joins).

Note that you can use the maxrows attribute in cfquery but that does not
usually help much.

[badLarry]

Thanks Mike. I'm using the SELECT * because I do use all the columns in the table. But I tried using TOP in the statement like you suggested and it was exactly what I was looking for . Thanks a ton.