Slow Portal

Classic Servoy
1

Hi Everybody,

This week, I just started to experiment with Servoy Developer. I felt right at home, since I’m coming from a Filemaker background.

However, I immediately noticed that Servoy’s portal is very slow, especially when the portal’d table has a large data set.

For example, I have an Order table and an OrderLineItem table. It was easy enough to create a relationship between Order and OrderLineItem, and then position a portal from the OrderLineItem on a form in Order. The Order table has 40,000 rows. The OrderLineItem table has 350,000 rows.

The problem is that flipping through each Order record, while viewing OrderLineItem portal takes about 5 seconds. Admittedly, the dataset is large. And using a MySQL admin tool, also takes about 3 to 4 seconds to execute a join query. But on Filemaker, a similar portal is fast…much too fast to measure.

Servoy can be fast, if I a viewing a form that is a list of Order records. Or if I am just viewing a list of OrderLineItems records. But a portal will slow record browsing to a crawl.

Here are the details of my environment. The only weakness I see is the 256 MB of RAM on the MySQL Server. Any help is greatly appreciated. Thanks!!

MySQL Server
Red Hat 7
Dual Process 2.4 Ghz
256 MB RAM

Servoy Developer
Windows 2000
Pentium-M 1.6 GHz
512 MB RAM

Gigabit LAN

2

We have not have had any complain about a portal so far, is your solution accessible over the web? so we can have a look?

3

Could it be that the field is not indexed, where the relation is going to?

4

Servoy uses only the pks for record handling, only the relation foreign keys column and columns where many user searches are performed on are candidates to be indexed.
So yes could indeed work faster when creating some indexes.

5

YES…the problem is indeed that the foreign key is not indexed. After indexing, it’s super fast to flip through the records.

Many thanks!!!