Record save execution time

Classic Servoy
1

The time it takes to save a record when you click out of a field seems to be running a little high in my solution. I have several forms, some with tabs and portals, some without. Oddly, all forms seem to have a high average save time. Anywhere from 3 to 6 seconds. My Servoy server lives on my SQL machine which seems to be powerful enough (3.0 GHz, 1.0 GB ram, Windows 2003). I do have around 70,000 records though. Is anyone else experiencing this type of behavior? This “hesitation” is making me have to consider a different front end other than Servoy.

Thanks,
Jim

2

for all kind of solutions?

for example a solution with one form with some few fields build on a new table?
Are only saves affected? So not display of data (then it would be a network problem or something like that)

if a query is going just fast then a update statement must also go very fast. If this is not the case then it has to be something with youre database.

3

You can browse my solution with the information provided. The main forms are the customertable, customertable2, and brochure. Those layouts all use the customertable with tabs and portals in various numbers and formats. If you edit some records and do some finds, you’ll be able to see the “hesitation/lag” I’m experiencing. It seems slow when scrolling though the record set, performing a find, updating records, and moving between forms. I’ve also set all indexes on the MS SQL side for the joins. Again thanks for the help, I’m sure I must be missing something.

SERVER:
http://207.234.146.248:8080

Test solution: Workamper

User: jcompagner
Pass: 123456

Thanks,
Jim

4

hmm

this is strange. There seems to be a lag between the client and youre server somehow.

This is what i see when i make a modification on one record:

one ‘burst’ of 2-3KB/s (sending the update query i take)
then quite a few seconds 800bytes/s
and then sometimes another small burst where you do
“select distinct custtype from customertable”

Do you also have this locally? With a developer on the same (or copy) of that database?

Is there a firewall or something between the server and the internet?

5

My development computer locally is set up with MS SQL and Servoy on the same Windows 2003 box, just like my web setup. It’s very fast, but as you can see the solution I put on the web is laggy. I had microsoft’s firewall installed on my web host. I’ve turned it off, but it hasn’t helped the speed issue that I can tell. Let me know of any other info you need to help resolve/identify the problem. I’m looking forward to finishing up my first Servoy project and rolling it out.

Again thanks for help,
Jim

6

After test my local solution and comparing it to my web solution, I’ve found them to be about the same speed. The local copy isn’t much faster than the web copy after all.

7

Funny it seems my local copy is faster at rendering the info. afterall. My web solution uses SQL for it’s repository and DB. But locally I’m using the default sybase repository and MS SQL for the DB. Could this be contributing to the “lag?”

Thanks
Jim

8

that has to be something that is causing the lag.

But what is fast and what is slow now?

solution on the web with its SQL database (Slow)
solution on the web with SQL db BUT running the client on the server itself (???)
solution on the web with a sybase or mysql or anyother database (???)
local solution with local sybase database (Fast)
local solution connecting to the SQL web database (???)