slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Datagrid SetFieldValue very slooow...

Guy Barrett
Posts: 63

Datagrid SetFieldValue very slooow... Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 May 10 10:12 AM

Hi All,

In order to prevent a full grid refresh after I have used some SQL statements to update back-end data, I am using SetFieldValue to simply update the values in the grid (multi-row-select, the SQL is run against each row selected).

The SQL runs like a rocket but SetFieldValue, whilst working, is extremely slow. The lookup field / key of the grid is indexed in the database, but my guess is that SetFieldValue works off the recordset behind the grid and doesn't use any indexes on the database.

My question is, how to speed this up? Is there anyway to apply an index to the grid recordset independent of the indexing in the database? Does the indexing on the database even have a bearing on how fast the SetFieldValue function works?

PS: The DBGrid has "IsSortable" set to "True" so it loads the whole of the grid contents into memory before displaying. This is because there is a large number of rows in the grid, and multi-select tends to go a bit wonky if "IsSortable" is not selected on large datasets.

Help! (Please) (Saleslogix 7.2 SP2)

[Reply][Quote]

Andrew Sokolsky
Posts: 26

Re: Datagrid SetFieldValue very slooow... Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 May 10 2:44 PM

Are you using WEB or LAN CLIENT?

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Datagrid SetFieldValue very slooow... Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 10 May 10 5:48 AM

This is obviously for the Windows Client.

The only other approach I could think of is to disconnect the Recordset, and then make changes against the recordset to mimic the changes on the DB.
It may still be slow as you would have to search through the recordset to find the affected rows.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/8/2025 5:01:11 AM