Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 234 Big Data Appliance
- 1.9K Data Science
- 449.7K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 157 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 387 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
Performance issue on IG page after Export/Import

Hello,
I think this has been happening on several of my recent applications, but I have only been able to pinpoint what was "causing" the problem with my current app. I have an Interactive Grid page that performs just fine until I Export/Import (for migrations). After I Import the app, my page is SUPER slow and basically just hangs. If I edit the page in the builder and go to the query and hit the space bar just to "register a change" (although nothing is really changing). After saving, it works fine again. I attempted to run the page with debug on and dont see anything indicative of a problem. It just takes forever.
We are running 5.1.4.00.08, but I believe this was happening in previous versions but I could never figure out when or how to reproduce it until now. I just noticed that one day my page was fine and the next it was SUPER slow and the only action I had taken was Export and Importing. I can reproduce it every time now. It even happens when I change nothing, but Export and Import into the same environment. Unfortunately, this is a fairly complicated app and it runs against our eBusiness suite database so I cannot reproduce it on oracle.apex.com.
Not sure if this is related, but I have several fairly complex (filters, aggregates, etc) saved custom report views within the IG.
I was just wondering if anyone else has seen this before? Perhaps people have experienced "seemingly random" performance issues, but have yet to connect it to Export/Import functions? Does anyone know what might change about a page/query during Export/Import that might be causing this? When I Export the file each time it looks exactly the same to me. At least I cannot see any indication of what might be changing between Export/Import.
Any thoughts?
Thank you,
Jen