sitecore's "latest" item

a whole settlement doubt sitecore 6...

lets contend have conditions where have 10,000 equipment implementing press release template. equipment stored sitecore during /sitecore/content/home/press/*. the homepage, wed arrangement information concerning 3 many new press releases.

were looking make something homogeneous sqls:

select tip 3 * pressreleases method releasedate

reading by sitecore query documentation, sounds decrease query contingency burnished the c# application. something like:

public item[] getrecentpressreleases()
{
   twine query = "/sitecore/content/home/press/*";
   item[] equipment = sitecore.context.database.selectitems(query);
   array.sort(items, new pressreleasedatecomparer());
   relapse items.take(3).toarray();
}

it seem loading 10,000 sitecore equipment database memory following classification each the homepage strike unsuited opening perspective.

is there some-more fit proceed demonstrate query? should i focused cost caching and/or pre-calculating?