[hibernate-dev] Keyset pagination support
Hi, I think it will be useful to consider adding support for Keyset pagination: http://use-the-index-luke.com/no-offset This could be a very strong feature that would set us apart from our competition. Vlad ___ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
Re: [hibernate-dev] Keyset pagination support
I would love that. We actually discussed such an approach a couple of years ago, but the context was not to implement pagination correctly but to improve the performance of the Hibernate Search mass-indexer (a batch process which iterates through all entities to rebuild the Lucene index). We eventually resolved that issue we had with transactions, but I still wonder if using comparable keys would give us better performance. The limitation is though that they need to be comparable.. is that always the case, and if not do you think we can figure it out easily from the SQL types? BTW, the article you point to seems to imply that without this feature it's impossible to do correct pagination, but while I'm not sure how people use Hibernate nowadays, when I used it for something similar within the JBoss Seam framework one would simply keep the repeatable-read transaction going so there would be no inconsistencies. This makes me think though that it might be useful for Hibernate Search users to be able to "freeze" the index view temporarily: https://hibernate.atlassian.net/browse/HSEARCH-2080 On 16 January 2016 at 09:58, Vlad Mihalcea wrote: > Hi, > > I think it will be useful to consider adding support for Keyset pagination: > > http://use-the-index-luke.com/no-offset > > This could be a very strong feature that would set us apart from our > competition. > > Vlad > ___ > hibernate-dev mailing list > hibernate-dev@lists.jboss.org > https://lists.jboss.org/mailman/listinfo/hibernate-dev ___ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
Re: [hibernate-dev] Forum database banned emails issue
It is documented here: - https://developer.jboss.org/wiki/ForumsAdministrationAccess However as you can see it's not easy to get to. You need to hop around several security checks and get authorization from each party. I can help with this as I already have access - if I remember the whole process ;-) - but you'll have to describe what you want me to do exactly. Do I need to wipe a large amount of data from a table? And do you have some example data to help me make sure I'm wiping the right table? Also please let me know if this is urgent: seems like a quite delicate matter and since I'm having a bit of fever now I'm afraid I'd mess up with the production db :) Sanne On 15 January 2016 at 22:09, Steve Ebersole wrote: > Sorry, I have no idea. That information is not listed in our private wiki > area. For anyone who knows this information, could you also update that > resources page? > > On Fri, Jan 15, 2016 at 4:57 AM Vlad Mihalcea > wrote: > >> Hi, >> >> I tried to import the last 24 hour forum spam emails form >> https://www.stopforumspam.com/, which is around 50k email entries. >> >> The email were imported, but now the banned email page of the forum doesn't >> load anymore. >> The problem is related to how phpBB renders the page since there's a >> dropdown where all emails must listed. >> >> Could someone delete a part of those entries or give me access to the DB so >> I can remove them myself? >> >> Vlad >> ___ >> hibernate-dev mailing list >> hibernate-dev@lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/hibernate-dev >> > ___ > hibernate-dev mailing list > hibernate-dev@lists.jboss.org > https://lists.jboss.org/mailman/listinfo/hibernate-dev ___ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
Re: [hibernate-dev] Forum database banned emails issue
Thanks Sanne, In the Administration Control Panel -> Maintenance, there's the Admin log. You can see there the emails that I added to the ban, along with the date they were submitted: Fri Jan 15, 2016 9:16 am I was thinking of deleting 5k emails from the ban list that were added at that date. I hope the DB records the time-stamp info, or at least we can use the Ids. I added those progressively and when there were 40k/45k entries, the page was still loading. Vlad On Sat, Jan 16, 2016 at 1:25 PM, Sanne Grinovero wrote: > It is documented here: > - https://developer.jboss.org/wiki/ForumsAdministrationAccess > > However as you can see it's not easy to get to. You need to hop around > several security checks and get authorization from each party. > > I can help with this as I already have access - if I remember the > whole process ;-) - but you'll have to describe what you want me to do > exactly. Do I need to wipe a large amount of data from a table? And do > you have some example data to help me make sure I'm wiping the right > table? Also please let me know if this is urgent: seems like a quite > delicate matter and since I'm having a bit of fever now I'm afraid I'd > mess up with the production db :) > > Sanne > > On 15 January 2016 at 22:09, Steve Ebersole wrote: > > Sorry, I have no idea. That information is not listed in our private > wiki > > area. For anyone who knows this information, could you also update that > > resources page? > > > > On Fri, Jan 15, 2016 at 4:57 AM Vlad Mihalcea > > wrote: > > > >> Hi, > >> > >> I tried to import the last 24 hour forum spam emails form > >> https://www.stopforumspam.com/, which is around 50k email entries. > >> > >> The email were imported, but now the banned email page of the forum > doesn't > >> load anymore. > >> The problem is related to how phpBB renders the page since there's a > >> dropdown where all emails must listed. > >> > >> Could someone delete a part of those entries or give me access to the > DB so > >> I can remove them myself? > >> > >> Vlad > >> ___ > >> hibernate-dev mailing list > >> hibernate-dev@lists.jboss.org > >> https://lists.jboss.org/mailman/listinfo/hibernate-dev > >> > > ___ > > hibernate-dev mailing list > > hibernate-dev@lists.jboss.org > > https://lists.jboss.org/mailman/listinfo/hibernate-dev > ___ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
Re: [hibernate-dev] Forum database banned emails issue
I Vlad, I'm sorry, it seems my credentials expired. I opened a ticket, it might take some time though. You might want to open a ticket to get credentials too. Sanne On 16 January 2016 at 11:42, Vlad Mihalcea wrote: > Thanks Sanne, > > In the Administration Control Panel -> Maintenance, there's the Admin log. > You can see there the emails that I added to the ban, along with the date > they were submitted: Fri Jan 15, 2016 9:16 am > > I was thinking of deleting 5k emails from the ban list that were added at > that date. > I hope the DB records the time-stamp info, or at least we can use the Ids. > > I added those progressively and when there were 40k/45k entries, the page > was still loading. > > Vlad > > On Sat, Jan 16, 2016 at 1:25 PM, Sanne Grinovero > wrote: >> >> It is documented here: >> - https://developer.jboss.org/wiki/ForumsAdministrationAccess >> >> However as you can see it's not easy to get to. You need to hop around >> several security checks and get authorization from each party. >> >> I can help with this as I already have access - if I remember the >> whole process ;-) - but you'll have to describe what you want me to do >> exactly. Do I need to wipe a large amount of data from a table? And do >> you have some example data to help me make sure I'm wiping the right >> table? Also please let me know if this is urgent: seems like a quite >> delicate matter and since I'm having a bit of fever now I'm afraid I'd >> mess up with the production db :) >> >> Sanne >> >> On 15 January 2016 at 22:09, Steve Ebersole wrote: >> > Sorry, I have no idea. That information is not listed in our private >> > wiki >> > area. For anyone who knows this information, could you also update that >> > resources page? >> > >> > On Fri, Jan 15, 2016 at 4:57 AM Vlad Mihalcea >> > wrote: >> > >> >> Hi, >> >> >> >> I tried to import the last 24 hour forum spam emails form >> >> https://www.stopforumspam.com/, which is around 50k email entries. >> >> >> >> The email were imported, but now the banned email page of the forum >> >> doesn't >> >> load anymore. >> >> The problem is related to how phpBB renders the page since there's a >> >> dropdown where all emails must listed. >> >> >> >> Could someone delete a part of those entries or give me access to the >> >> DB so >> >> I can remove them myself? >> >> >> >> Vlad >> >> ___ >> >> hibernate-dev mailing list >> >> hibernate-dev@lists.jboss.org >> >> https://lists.jboss.org/mailman/listinfo/hibernate-dev >> >> >> > ___ >> > hibernate-dev mailing list >> > hibernate-dev@lists.jboss.org >> > https://lists.jboss.org/mailman/listinfo/hibernate-dev > > ___ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
Re: [hibernate-dev] Forum database banned emails issue
I tried to access this page: https://developer.jboss.org/wiki/ForumsAdministrationAccess But I get: Unauthorized Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here. On Sat, Jan 16, 2016 at 3:05 PM, Sanne Grinovero wrote: > I Vlad, > I'm sorry, it seems my credentials expired. I opened a ticket, it > might take some time though. > You might want to open a ticket to get credentials too. > > Sanne > > On 16 January 2016 at 11:42, Vlad Mihalcea > wrote: > > Thanks Sanne, > > > > In the Administration Control Panel -> Maintenance, there's the Admin > log. > > You can see there the emails that I added to the ban, along with the date > > they were submitted: Fri Jan 15, 2016 9:16 am > > > > I was thinking of deleting 5k emails from the ban list that were added at > > that date. > > I hope the DB records the time-stamp info, or at least we can use the > Ids. > > > > I added those progressively and when there were 40k/45k entries, the page > > was still loading. > > > > Vlad > > > > On Sat, Jan 16, 2016 at 1:25 PM, Sanne Grinovero > > wrote: > >> > >> It is documented here: > >> - https://developer.jboss.org/wiki/ForumsAdministrationAccess > >> > >> However as you can see it's not easy to get to. You need to hop around > >> several security checks and get authorization from each party. > >> > >> I can help with this as I already have access - if I remember the > >> whole process ;-) - but you'll have to describe what you want me to do > >> exactly. Do I need to wipe a large amount of data from a table? And do > >> you have some example data to help me make sure I'm wiping the right > >> table? Also please let me know if this is urgent: seems like a quite > >> delicate matter and since I'm having a bit of fever now I'm afraid I'd > >> mess up with the production db :) > >> > >> Sanne > >> > >> On 15 January 2016 at 22:09, Steve Ebersole > wrote: > >> > Sorry, I have no idea. That information is not listed in our private > >> > wiki > >> > area. For anyone who knows this information, could you also update > that > >> > resources page? > >> > > >> > On Fri, Jan 15, 2016 at 4:57 AM Vlad Mihalcea < > mihalcea.v...@gmail.com> > >> > wrote: > >> > > >> >> Hi, > >> >> > >> >> I tried to import the last 24 hour forum spam emails form > >> >> https://www.stopforumspam.com/, which is around 50k email entries. > >> >> > >> >> The email were imported, but now the banned email page of the forum > >> >> doesn't > >> >> load anymore. > >> >> The problem is related to how phpBB renders the page since there's a > >> >> dropdown where all emails must listed. > >> >> > >> >> Could someone delete a part of those entries or give me access to the > >> >> DB so > >> >> I can remove them myself? > >> >> > >> >> Vlad > >> >> ___ > >> >> hibernate-dev mailing list > >> >> hibernate-dev@lists.jboss.org > >> >> https://lists.jboss.org/mailman/listinfo/hibernate-dev > >> >> > >> > ___ > >> > hibernate-dev mailing list > >> > hibernate-dev@lists.jboss.org > >> > https://lists.jboss.org/mailman/listinfo/hibernate-dev > > > > > ___ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
