Servoy 5.2.16 Is slow after upgrade

The forum to discuss the Headless version of Servoy. Web, Java and Servlet development questions can all be posted here.

Servoy 5.2.16 Is slow after upgrade

Postby lhale » Thu May 02, 2013 5:55 pm

I recently upgraded from 5.2.7 to 5.2.16 as a result we are experiencing lockups in the client and blackscreens. We are running an ubuntu 6.06 appserver with -xmx 2048Mb of memory and mostly windows 7 clients, java 6.

Any help would be appreciated.
Posts: 108
Joined: Mon Mar 17, 2008 3:49 pm

Re: Servoy 5.2.16 Is slow after upgrade

Postby jcompagner » Tue May 21, 2013 5:54 pm

this is very hard to say what could go wrong.
Do you have a smart client that i can open and where i can see the hangs?
Johan Compagner
User avatar
Posts: 8454
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Servoy 5.2.16 Is slow after upgrade

Postby lhale » Wed May 22, 2013 10:44 pm

I finally figured out what was going on. My solution was getting bogged down big time from the get. I supercharged the my.cnf for mysql which helped. Cleaned up duplicate indexes and added new indexes for all the inital sorts on form loads.
Converted my solution to not preload any data into the foundset. Added databaseManager.setCreateEmptyFormFoundsets() to my solution open function. This by far boosted our system to the best performance it has ever seen. I only preload selective data now through the onload event on certain forms. One of our tables that has 1.5 million records that was causing us issues when preloading is now very fast. Users can search for their desired data. As a result everything just loads alot faster with almost no lag. The link below pretty much fixed my issue. I guess 5.2.16 really wasn't the problem after all or maybe it handled things differently.

This article literally helped supercharge my system.

So in short my solution:

1. Added databaseManager.setCreateEmptyFormFoundsets() to solution open
2. Removed duplicate indexes and added indexes for all form sorts ( Added indexes to mysql database fields that are used in the initial sort of form loads)
3 Supercharged the mysql database by tweaking the my.cnf ( Google and monitoring my database help be get this right).
Posts: 108
Joined: Mon Mar 17, 2008 3:49 pm

Return to Servoy Headless Client

Who is online

Users browsing this forum: No registered users and 1 guest