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
