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
