Re: [smartweb-devel] Hibernate hql,sql query slow pagination

[Roberto Lo G. <rlo...@sm...>]

Again, and for the sake of honesty, neither you are allowed to vote on
the SmartWeb Project (you are allowed to vote on the auth module but
not on the core), but we'll take in account your opinion.

May be we need to be more precise on membership roles on the site.

Anyway I'll take the opportunity to express my vote:
  +1 to the count method
  +1 to the alien package into smartweb.jar

Obviously the premise is to switch to default Hibernate if and when
thay decide to provide such feature through their official API.

2007/11/6, svetrini <st...@gm...>:
>
> I vote for the  solution with the count method and to  adding packages to
> smartweb (waiting for hibernate patch, obviously!)
>
> good work
>
>
> Gaetano Perrone wrote:
> >
> > Until hibernate group answer to our patch request I suggest a vote for one
> > of the following solution :
> > I remember all that the problem is to modify a given hibernate query(hql
> > or sql query) to count the results without extracting it.
> > The problem that requires the hibernate patch is the retrieving of the
> > query parameters for a given hibernate query, because of the protected
> > visibility of the getNamedParams(), getTypes(),getValues() (positional
> > parameters). To solve the problem there are two approch:
> >
> > 1. Make the protected  methods getNamedParams(), getTypes(),getValues() on
> > the AbstractQueryImpl hibernate class public.
> >
> > 2. Adding on the hibernate QueryImpl SqlQueryImpl final class a public
> > count() method in addition to list(), uniqueResult() methods.
> >
> > For each approch there was anothere choice to do until hibernate group
> > approves the patch:
> >
> > a) adding an org.hibernate(needed only by the second solution with the
> > patched Query class ) and org.hibernate.impl (with the patched
> > AbstractQueryImpl class for the first solution and the QueryImpl and
> > SQLQueryImpl for second solution)package to smartweb framework
> >
> > b) Provide for smartweb user's that would use fast hql/sql pagination an
> > zip file with the patch to apply to hibernate jar as an external resource.
> >
> > I suggest a vote for the 2 choices. I hope u answer soon...
> >
> >
>
> --
> View this message in context: http://www.nabble.com/Hibernate-hql%2Csql-query-slow-pagination-tf4751460s17546.html#a13614378
> Sent from the SmartWeb Developers mailing list archive at Nabble.com.
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> smartweb-devel mailing list
> sma...@li...
> https://lists.sourceforge.net/lists/listinfo/smartweb-devel
>