Hi YSL,

What about my last response: Did you check the query plans, could you
observe any improvements?

Best,
Christian




On Mon, Mar 2, 2020 at 7:44 AM Sreenivasulu Yadavalli
<srinivasuluy75@gmail.com> wrote:
>
> Hi Christian,
>
> We're having a requirement to move Our application to AWS cloud.
>
> Please suggest on how to use Base-X DB on AWS cloud environment ?
>
> Regards,
> YSL
>
> On Tue, Feb 11, 2020 at 12:31 AM Christian Grün <christian.gruen@gmail.com> wrote:
>>
>> Hi YSL,
>>
>> You could try to rewrite the number test to a string comparison:
>>
>> OLD:
>>   ....[AccNo[@NO = (12345)]]
>>
>> NEW:
>>   ....[AccNo/@NO = '12345']
>>
>> If you run your query, are some expressions rewritten for index
>> access? Just have a closer look at the Info View output and look for
>> "applying... index" strings.
>>
>> Best,
>> Christian
>>
>>
>>
>> On Mon, Feb 10, 2020 at 11:49 AM Sreenivasulu Yadavalli
>> <srinivasuluy75@gmail.com> wrote:
>> >
>> > Dear Christian,
>> > Please find the attachment for query
>> >
>> >
>> >
>> > Regards,
>> > YSL
>> >
>> >
>> > On Mon, Feb 10, 2020 at 3:59 PM Christian Grün <christian.gruen@gmail.com> wrote:
>> >>
>> >> Hi Sreenivasulu,
>> >>
>> >> > Please suggest any clue to tune the query.
>> >>
>> >> Which query?
>> >>
>> >> Best,
>> >> Christian
>> >>
>> >>
>> >>
>> >> >
>> >> > Regards,
>> >> > YSL
>> >> >
>> >> >
>> >> >
>> >> > On Mon, Dec 30, 2019 at 1:07 AM Christian Grün <christian.gruen@gmail.com> wrote:
>> >> >>
>> >> >> Dear Sreenivasulu (cc to the list),
>> >> >>
>> >> >> Thanks for the Java code; I could reproduce the behavior.
>> >> >>
>> >> >> A new stable snapshot will be available in a few minutes [1]; could
>> >> >> you check for us if it resolves the problem?
>> >> >>
>> >> >> Thanks,
>> >> >> Christian
>> >> >>
>> >> >> [1] http://files.basex.org/releases/latest/
>> >> >>
>> >> >>
>> >> >> > On Fri, Dec 20, 2019 at 10:59 AM Sreenivasulu Yadavalli
>> >> >> > <srinivasuluy75@gmail.com> wrote:
>> >> >> > >
>> >> >> > > Hi Christian,
>> >> >> > >
>> >> >> > > Currently, as part of our business use case we are receiving some XML file, which contains special characters like semicolon ": " in the file names.
>> >> >> > >
>> >> >> > > We're able to get process using the memory file stream,
>> >> >> > > File ofile= new File("<<FILEPATH");
>> >> >> > > FileInputStream xmlFile = new FileInputStream(ofile);
>> >> >> > > clientSession.add(<<FILE_NAME>>, xmlFile);
>> >> >> > >
>> >> >> > > We're not able to process these files using the command ADD
>> >> >> > > clientSession.execute("ADD <<FILE_PATH>>");
>> >> >> > >
>> >> >> > > Kindly suggest us the way forward \ alternative approach to the resolve the concern at earliest.
>> >> >> > >
>> >> >> > >
>> >> >> > > Regards,
>> >> >> > > YSL
>> >> >> > >
>> >> >> > >
>> >> >> > > On Tue, Dec 17, 2019 at 11:48 AM Sreenivasulu Yadavalli <srinivasuluy75@gmail.com> wrote:
>> >> >> > >>
>> >> >> > >> Hi Team,
>> >> >> > >>
>> >> >> > >>
>> >> >> > >>
>> >> >> > >>
>> >> >> > >>
>> >> >> > >> We have a big problem for creating the collection bcoz of large no of xmls.
>> >> >> > >>
>> >> >> > >>
>> >> >> > >>
>> >> >> > >> Every day we are moving collections around 55k to 60k no of xml files large account. Its taking more than 18 hours. At that time we want access the collection for generating report its on lock mode and scrip that collection.
>> >> >> > >>
>> >> >> > >>
>> >> >> > >>
>> >> >> > >> Please help and do needful.
>> >> >> > >>
>> >> >> > >>
>> >> >> > >>
>> >> >> > >> Regards,
>> >> >> > >>
>> >> >> > >> YSL