Re: [Modeling-users] Fetching limited numbers of rows

[Sebastien B. <sbi...@us...>]

        Hi Dennis and all,

  To all: if you're using the "Fetch slices and sort orderings" patch,
  I need your feedback, see at end of msg.

Kertis, Dennis wrote:
> Is there a way to tell Modeling to only fetch the first N rows?=A0 Ideall=
y,
> I'd like to be able to specify an offset and a count to do something like
> paging results of a search.

Thanks Mario for the references you posted, I appreciate not having to
search the archives ;)=20

  As Mario already answered, there is a patch doing what you want
  (offset and count in ec.fetch()) You'll find example in the announce,
  hopefully you'll find this useful, and if you need more informations
  then do not hesitate to ask.

Related announce is at:
  http://sourceforge.net/mailarchive/message.php?msg_id=3D7163083
And the patch is at:
  http://sourceforge.net/tracker/index.php?func=3Ddetail&aid=3D892454&group=
_id=3D58935&atid=3D489337

Mario Ruggier <ma...@ru...> wrote:
> Hi, there were a few discussions on this a while back, including a pretty
> well-defined proposal to add offset and paging capabilities. Sebastien had
> also worked on it in a branch, but I do not know what the status of that =
is
> now.=20

  The status is: wait for comments ;)  It seems that some of you out there
  use this patch, could you please comment? In particular:

     | Current limitations are:
     |=20
     |   - it is available/tested for Postgresql and MySQL only
     |=20
     |   - parameter isDeep shouldn"t be set w/ fetch slices and/or with
     |     sort orderings,
     |=20
     |   - inserted (unsaved) objects will appear at the end of each
     |     result set when limit and/or orderBy is set.  is the
     |     limitation of having inserted objects

  Do you find this annoying?  With which database adaptor(s) do you use
  it?  I'm asking this because it's out there for a long time, and it's
  probably time to integrate it into the main trunk (geez, I can't
  believe the original proposal was more than a year ago!)

-- S=E9bastien.


Mario Ruggier <ma...@ru...> wrote:
> Search the mailing list archive for "offset"... but the main thread about
> this was:
>=20
> API cleanup proposal =A0
> http://sourceforge.net/mailarchive/message.php?msg_id=3D5142917
>=20
> limiting the amount of objects retrieved =A0
> http://sourceforge.net/mailarchive/message.php?msg_id=3D7163083
>=20
> limit
> http://sourceforge.net/mailarchive/message.php?msg_id=3D4159154
>=20
> mario