smartweb-devel

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

[Gaetano P. <gpe...@sm...>]

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#a13586351
Sent from the SmartWeb Developers mailing list archive at Nabble.com.

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

[Pino C. <gco...@gm...>]

I vote for first choice adding  the new package..waiting for an hibernate
group answer.



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#a13587401
Sent from the SmartWeb Developers mailing list archive at Nabble.com.

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

[rlogiacco <rlo...@us...>]

Pino Contartese wrote:
> 
> I vote for first choice adding  the new package..waiting for an hibernate
> group answer.
> 

Hi Pino,
we welcome your opinion and contribution about the topic, but you are not
allowed to vote as you are not (yet?) a voting developer on the SmartWeb
Project Community.

If you are interested in becoming a voting developer please refer to our
Contributor Guide (http://smartweb.sourceforge.net/contrib-guide.html) for
more informations.

I wish to assure you your opinion (as the other ones we could receive in the
meantime) is taken in great consideration by the Project Committee as our
decision is mainly focused to your satisfaction :-)

Thank you,
  Roberto Lo Giacco

-- 
View this message in context: http://www.nabble.com/Hibernate-hql%2Csql-query-slow-pagination-tf4751460s17546.html#a13588547
Sent from the SmartWeb Developers mailing list archive at Nabble.com.

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

[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.

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
>