Error with databaseManager.getDatasetByQuery()

Classic Servoy
1

HI,

I have a problem,when I tryed to use “databaseManager.getDatasetByQuery” and the result of query returns 85000record,
then Servoy go in crash.

i still using servoy 4.1.3 with windows xp

Thanks at all :)

Marco

2

Any error stack?

Most likely you’re running out of memory.

Paul

3

No error stack…in fact the servoy client-istance ( launched by the developer) freezes…than
I have to stopped servoy process into task manager and restart servoy.

if I’m running out of memory what I have to do to perform a query? In my case after the query
I create a datasource by dataset for the solutionModel-form creation.

Any suggestion to solve my problem?

4

You mean your Smart Client instacne connected to Developer or to an Application Server. If the latter, please start with the Java WebStart console enabled, because I’m sure there is some stacktrace in there.

If the client freezes, it really sounds like a memory issue.

You can either increase the available memory for the client, or not select 80k of records into memory.

Paul

5

Ok!

Thank to all for the help :)