Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
jpesout

Avatar / Picture

Veteran
Registered:
Posts: 107
Reply with quote  #1 
Do you have any experience with editable grids based on large tables (thousands rows)? The grid worked fine, but after data import, every insert/update is very slow (minutes). I thought that only edited rows are updated in database, but it seems that grid is updating all rows? Unfortunatelly I can't profile it right now, so I am not sure about that.
Am I doing something wrong, or do I need some filtering or ro grid with edit form for that?
Thanks in advance.
Edit: The grid has enabled paging (20 rows)
0
suityou01

Avatar / Picture

Veteran
Registered:
Posts: 213
Reply with quote  #2 
Grid bound to table BO? Is the table a custom table? Does it have indexes?

For info, the table BO holds an in memory dataset. The delta (ie changed row) is commited to the database when you update the row, but the dataset is not refilled as the in memory dataset holds the change already.

The table BO is filled on form load.

Can you flip on network analyser in IE and see what the roundtrip times are like for any ajax queries.
0
jpesout

Avatar / Picture

Veteran
Registered:
Posts: 107
Reply with quote  #3 
It is a solution table with identity primary key and some text columns, no indexes. Grid is placed on admin form.
Actually, insert or update to the grid is fine, but submit or cancel button on the admin form freeze (with Stop JavaScript dialog). Based on my observation, the change to the database is commited after submitting form, isn't it?
I will check the ajax calls and probably set up the profiler, thanks for the tip.
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #4 
I have noticed that even a hundred or so records will make it quite slow. I believe it goes through each record and looks to see if it has changed. It may update each record too, I am not sure.

Filtering the results is the best way, of the old 'add/update/delete' and RO grid, as you say. Unless many updates are required at once, the RO grid seems OK. We use it quite effectively with chained actions (one action per update/add/delete) in the Business Rule section of the Release Management solution. With many updates it is a pain, however.

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
suityou01

Avatar / Picture

Veteran
Registered:
Posts: 213
Reply with quote  #5 
Not sure that's quite right. How would it work if you had a dependant grid. You wouldn't submit the form and then open it back up again just to add a child row.

How did you get on with network analyser?
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #6 
Yup, form submits & reopens. It is quite fast as the form is simple. I was trying out the concept and quite liked the result, but I would not use it in all situations.
__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!