Which database are we talking about? Doesn't it support LIMIT or something similar?
Depending on that selecting a constant would still force you to go through all rows to get the correct amount so a count would probarbly be as effective -- Jakob Tikjøb Andersen +45 25 277 105 On Thu, Aug 6, 2009 at 1:20 PM, Marvin Massih <[email protected]>wrote: > > On 6 Aug., 13:10, Jakob Tikjøb Andersen <[email protected]> wrote: > > Select only one row by using SetMaxResult to one, thats probarbly the > > fastest way to go about it. You query would still touch every single row > in > > database. > > Sorry, I forgot to say I have to support a crappy database that > doesn't support "SELECT TOP". > Is there no way to select a constant? > > Thanks, > Marvin > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
