Performance / Memory

Classic Servoy
1

It seems that Servoy is getting quite sluggish during development, going between design mode and browse mode.

Has anyone else had these issues?

Version R2 2.1rc2-build 306
Java version 1.4.2_05-b04 (Windows XP)
P4, 256mg

SQL 2000 on local machine.

Servoy is using 54,200k of memory.

So far my solution is relativley small as I am still playing, I only have one table that I have done a test import of 2500 records. By the time the solution will have grown significantly. I will also be importing years worth of data(thousands of records) over 60 - 70 tables.

I guess I am a bit concerned in regards to performance. I have a method that does a simple find / search (criteria entered 2 text fields) and shows a listing and it seems a bit sluggish.

I realize that there will be significant increases in performance when running queries, using arrays and html formating compared to Filemaker reports.

I use alot of Queues that are just simple lists for department work bins, and they are twice as slow as filemaker. Is this expected performance?

2

i don’t know what makes it sluggish at youre place
For example is the demo you see on: http://demo.servoy.com:8080 also sluggisch?

Where do you see the 54.200K number? In the task manager? Or in the about window of servoy?

It shouldn’t matter how many tables you have. Or how many records are in those tables. Because servoy itself is not bothered by that. The only limitting factor is then the database. (and with good indices you won’t notice much)

3

This is the task manager

4

In the taskmanager it will use up to 64Mb max (if not changed the default mem. use in admin page), see the Servoy about dialog for real mem. use by the JavaVM