Jpype startjvm is taking long time

Aspose.Cells Product Family
1

Hi There,
We are using the “demo” aspose.cells at the moment.
But it takes at least 10 seconds before jpype.startjvm is executing.
Can anybody help us out with this?

Thanks.

2

@Eurotrol,

Could you please share environment details, e.g., OS and its version (e.g., Windows, Linux MacOS, etc.), Python version, JDK version, etc. Also, did you set the JAVA_HOME and PATH environment variables properly?

3

Hi,

Thanks for the quick response.

OS: Windows server 2016
Python: 3.9.6(64bit)
JDK: 17.0.2

For what we can see is JAVA_HOME correctly filled in: “C:\Program Files\Java\jdk-17.0.2\bin\server”

4

@Eurotrol
Thanks for providing us environment details. I’ll spend some time replicating your problem in the same environment.

5

We are starting the jvm with the following code:

    if not jpype.isJVMStarted():
        jpype.startJVM()

    if not jpype.isThreadAttachedToJVM():
        jpype.attachThreadToJVM()

   from asposecells.api import Workbook, SaveFormat, CalculationOptions
6

@Eurotrol
Could you please try the below code to evaluate the startup time of startJVM without loading asposecells?

import jpype
if not jpype.isJVMStarted():
        jpype.startJVM()
7

hmmm, that’s going good.
Proberly has to do with the asposecells jsonutility.importdata…

8

@Eurotrol
Please provide us your json file, we will improve the performance of jsonutility.importdata. Thanks.

9

can we do some memory optimalization for big files?

10

@Eurotrol
I have logged a ticket with an id “CELLSJAVA-44992” for your issue. We will look into the details of the problem soon.

Once we have an update on it, we will let you know.

11

I have a big json file. How can i share that with you?

12

@Eurotrol
You can upload to dropbox ,google drive or other cloud storage.
BTW, Could you share your sample project ?