We use ORDS for APEX and for RESTful Services.
We have a number of RESTful services (for use from e.g. Excel Power Query), that fetch time series data. To fetch a series for a year it gets 35136 values (one value per 15 minutes), and users may wish to fetch many of such series in one go.
If I execute the query as defined in the REST module from SQLDev (using <ctrl>A to fetch all rows) it takes 1.8 sec to get a whole year of 1 series, which is acceptable for the usage.
If I fetch by entering the corresponding URL in the browser it takes about 20-30 sec. It seems that the conversion of the result set to JSON takes most of the time. I cannot imagine that such a conversion should take much time, so what is the reason?
Any suggestions? Or could this be improved by the development team of ORDS?
ORDS is running on GlassFish. Might it help to give the JVM of the GlassFish instance more memory?