IssueTracker

That seems quite bad :/ weird.
We have fairly large test projects which do not take anywhere close to it, maybe your code is triggering some bad code path.

Can you provide a sample or share  your project with us? It is impossible to do something here unless we have a reproduction case. Might also possibly be related to your machine configuration.

Let me see what I can do on the reproduction as I am anyways blocked on this. I will try to extract out the DB module in a new project and see if it reproduces the issue.

Attaching the sample project. When I run the project through the android studio or even command line, I see the described issue.
Try uncommenting room-compiler dependency from app's build.gradle, it does not have the issue because room compiler is not at work.

Did you get a chance to look at it?

FYI. I see that if I comment out applying google-services plugin (at the end of the app's build.gradle file), that fixes the issue too. Hence, you may need to apply a google-services plugin with a json file to reproduce the issue.

Not sure what is going on but certainly, somethings are not playing well together.

Above comment is NOT TRUE, it seems I did not do a code change after commenting out apply google-services plugin. That's why the build passed.

Thanks for the sample app. I haven't gotten to the bottom of the issue yet but I wanted to give you an update and it does seem indeed that Room is taking a very long time to parse and understand your queries via the ANTLR generated parser that Room uses. I'm not sure what is so special about your queries that is causing this, but I'll comment back with an update once I find out. Sadly for now I don't have a recommendation on a workaround.

Alright, I've drill down the problem to being the various "OR <col_name> LIKE '%' : text '%'" in your queries. Specifically they cause the SQLiteParser in Room to go down a path with poor performance as described in https://github.com/antlr/antlr4/issues/1398. A fix for this involves updating Room's ANTRL runtime library and generated parser code with the latest version. This update will likely be available in Room 2.1.0-alpha02.

Thanks for the update. Is 2.1.0-alpha02 around the corner?

Project: platform/frameworks/support
Branch: androidx-master-dev

commit 8e46b9ca1f55b040a18dd86833880b5106d103b2
Author: Daniel Santiago Rivera <danysantiago@google.com>
Date:   Wed Oct 10 19:17:50 2018

    Update Room's ANTLR Parser to 4.7.1
   
    Updating to the latest ANTLR version fixes the performance issue
    described in https://github.com/antlr/antlr4/issues/1398 which affects
    Room's SQL Parser since it contains left-recursive rules. Specifically
    SQLite.g4 has multiple recursions to describe an expression as defined
    in https://www.sqlite.org/lang_expr.html, meaning if a user has certain
    queries that causes the parser to use the adaptivePredict algorithm
    then the build time increases significantly due to Room's query
    parsing.
   
    Also bumped Room's version to 2.1.0-alpha02
   
    Bug: 117401230
    Test: ./gradlew room:integration-tests:testapp:cC
    Change-Id: I4d0799a11ccee816ab209cbf74e7dcf2b2ce1a18

M       buildSrc/src/main/kotlin/androidx/build/LibraryVersions.kt
M       buildSrc/src/main/kotlin/androidx/build/dependencies/Dependencies.kt
M       room/integration-tests/testapp/src/androidTest/java/androidx/room/integration/testapp/dao/UserDao.java

https://android-review.googlesource.com/786077
https://goto.google.com/android-sha1/8e46b9ca1f55b040a18dd86833880b5106d103b2

No concrete date on 2.1.0-alpha02, I want to get a few more bugs in before making the next alpha release. So maybe by the end of the month.

Thanks.

On Tue, Oct 16, 2018, 4:52 AM <buganizer-system@google.com> wrote:

--

- Ankit

yes, it is a bug,
explanation:
emulator 31.2 takes absolute path first, and 31.3 take relative path first.
it turned out relative path code path ignores the ANDROID_AVD_HOME (both 31.2 and 31.3 ignore), and that only
works for default ANDROID_HOME setup (/home/user/.android)

will fix this

sorry for the inconvenience and thanks for reporting the bug to us.

could you please download and try this build to see if it fixed the problem, let me know

https://ci.android.com/builds/submitted/9117533/emulator-linux_x64/latest/sdk-repo-linux-emulator-9117533.zip

hopefully 1 or 2 weeks.

This bug is fixed by the most recent Stable Emulator release, 31.3.12: https://developer.android.com/studio/emulator_archive

I certainly don't know what to do at this point, I have had 3 cell phones and 3 computers and a Chromebook all reconfigured and they were not even open out of the box in the case of the Chromebook and the hp All in one, 3 cell phones bootlocked and the deffrent types of platforms of each component of the vertual box in which e have to call it for what it is. The activity surrounding my devices in this instance is also the same as the activity surrounding my devices and cyber security breaches and identity theft and cyber exploits I recall in December 31,201. To August of 2021. The use of X86, System 32,64, Android9 pie and below, Windows NT, iOS, sequel, XML, Emulators and Ghosting, casting, broadcast and interaction with my actions in real time in visual and text, and auto correct of a click or choice of words with certain systems in the accounts for the same platforms as of today. Google, Chromium is is a component of the ratio so is chrome OS, firebase as a identifyer but not a component, Windows is affected, Android, Apple, Amazon flypads are very operational in this environment and they are used for the activity monitoring in some occasionally. In this hybrid Linx. Is the major part of the ratio of the different codes. Meta data was very operational in the activity of my windows 11 HP All inn One, my program files were of the meta data type and python was also used. I don't want to ramble on this subject for the reason that I have lost the majority of the data back ups, and the researching I had to take on when I was first exposed to the vertual Box. I probably would have a very detailed and technically correct of terms for the activity of the ratio so much so is that the same in astute use of a tunnel to deliver to intubation and the details of the IP address and the Protocol for the activity of the Modems and ro the gateways identity the value of the:,.,0,= f,E this instance it was the use of a dummy and the ipv4, Asus WRT-CMd-Exe , for the Network and the Windows, and the Androids it was a file to the chrome in the download and I had to delete it, but it was not a update I had down loaded. It was a guesture of interaction with my actions and my intrests as the activity is very disturbing the Tayloring of the individual is very befriending and the isolation of the exhausting tasking and the persistent,. It occupies and I have been trying to take on an old friend with a very interesting infatuation of the Devices and the details of what I utilize them for or any subsequent to reprogram a operate to the very befriending of my rights in some of the activity of the data that I have I think to myself and have to be aware that this is very disturbing and I have to allow it or any other case there's no way to stop it.

tonyvg2013@gmail.com

Tony if you want to contact me for some questions or related topic it would be great.

I have been a whitness for the activity of my friends and others over 35 individual cases of the same MO.