nop, I will try now On Sat, Jan 18, 2020 at 7:05 AM Florian Westreicher <st...@meredrica.org> wrote:
> Have you tried to use a mango query? They are drastically more performant > than views, especially when you order documents. > > > On January 17, 2020 18:12:04 "Betto McRose [icarus]" <mcrose....@gmail.com> > > wrote: > > > this is the query > > http://host:port/databaseName/_design/non-migrated/_view/ > > non-migrated-view?descending=true&limit=100 > > > > On Fri, Jan 17, 2020 at 10:29 AM Florian Westreicher < > st...@meredrica.org> > > wrote: > > > >> It would help if you provide the REST calls or the queries you use. > >> > >> Sounds like you are using something with very poor performance. > >> > >> On January 17, 2020 13:42:33 "Betto McRose [icarus]" < > mcrose....@gmail.com> > >> > >> wrote: > >> > sorry, I'm not english speaker > >> > > >> > well, I didn't get the response > >> > I just moved the code to the java-ee 8 and worked, may be is the > quarkus > >> > rest api the problem > >> > but, I had to configure the wildfly's transaction-timeout to 3600 > >> > > >> > I have a scheduler who runs every 30 segs (I guess I didn't mention > this > >> > before) > >> > queries for 100 'not migrated' documents > >> > creates entities and persist them to a mmsql database > >> > updates those 100 documents to 'migreated' via _bulk > >> > > >> > sometimes, I got no response after 2000 updates, or just 100 > >> > this is the code for the last test that went ok with 800 documents > >> > > >> > > >> > I was reading http://guide.couchdb.org/draft/performance.html but > there > >> is > >> > no "special" configuration to set > >> > > >> > I will make more test during next week, to see if happens again > >> > > >> > > >> > On Thu, Jan 16, 2020 at 3:28 PM Robert Newson <rnew...@apache.org> > >> wrote: > >> > It’s not clear what you’re reporting here. > >> > > >> > Do you get a response or not? > >> > If you do, please show it. > >> > If not, check couch.log for output from that time and show that. > >> > > >> >> On 16 Jan 2020, at 14:09, Betto McRose [icarus] < > mcrose....@gmail.com> > >> wrote: > >> >> > >> >> Hi all > >> >> I got this issue I can't figure out what I'm missing > >> >> I have tested in two applications: one with java-ee 8, the other in > >> quarkus > >> >> both calls CouchDB REST API for post() and _bulk operations > >> >> > >> >> with java-ee I made some tricks because I need to create a document > with > >> >> every entity, from a mmsql record and went fine > >> >> > >> >> but with quarkus app, I need to: > >> >> -retrieve 100 non-migrated documents (could be more) > >> >> -create 100 entities and persist in mmsql --no problems till here-- > >> >> -updates those 100 documents with 'migrated' back to CouchDB > >> >> first with one-by-one, now in a bulk operation > >> >> ---still no problems till here-- > >> >> > >> >> the problem appears when (and depends on ???, still don't know) > >> >> do the query for the 'next' 100 or calls for bulk insert/update > >> operation > >> >> > >> >> doing one by one occurs after 50 inserts/update > >> >> or calling the _bulk, occurs after 20 times > >> >> > >> >> calls the REST API and stops there > >> >> > >> >> CouchDB is installed with default values > >> >> on a Windows 10 PRO i7 > >> >> with 16GB RAM > >> >> and 500GB SSD > >> >> > >> >> > >> >> > >> >> > >> >> -- > >> >> > >> >> > >> >> [image: --] > >> >> > >> >> [icarus] > >> >> [image: https://]about.me/mcrose > >> >> <https://about.me/mcrose?promo=email_sig> > >> >> Betto McRose > >> >> Java/JavaEE Developer > >> > > >> > > >> > > >> > -- > >> > > >> > > >> > > >> > [icarus] > >> > about.me/mcrose > >> > > >> > > >> > > >> > > >> > > >> > > >> > Betto McRoseJava/JavaEE Developer > >> > >> > > > > -- > > > > > > [image: --] > > > > [icarus] > > [image: https://]about.me/mcrose > > <https://about.me/mcrose?promo=email_sig> > > Betto McRose > > Java/JavaEE Developer > > > > -- [image: --] [icarus] [image: https://]about.me/mcrose <https://about.me/mcrose?promo=email_sig> Betto McRose Java/JavaEE Developer
