Shifting contents of edittables ... performance issue (OpenInsight 16-Bit Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Shifting contents of edittables ... performance issue (OpenInsight 16-Bit Specific) ====
=== At 24 MAY 2002 06:10:25AM Godfrey Farrugia wrote: ===
 
{{tag>"OpenInsight 16-Bit Specific"}}
 
<QUOTE>
I have a performance-related issue. On a form, I have several identically-structured edittables side-by-side and I need to shift their contents around, i.e. contents of table-2 to overwrite contents of table-1, contents of table-3 to overwrite those of table-2, and so on.



I achieved this via a FOR ... NEXT loop (using successive iterations of Get_Property from table-n and then Set_Property on table-n-1) but performance is sluggish and noticeable in operation.



What is the best way to achieve this performance-wise? Two possibilities come to mind:

1. Successively DESTROYing and reCREATEing each edittable, meanwhile changing the name of control table-n to table-n-1 and changing SIZE to leave it in its original place on the form. But will this improve performance vs the Get_Property/Set_Property alternative?

2. I have never used the STRUCT facilities and they imply this can be done. Is this so, and will they work faster?



Any help will be appreciated.
</QUOTE>
----

=== At 24 MAY 2002 06:26AM Oystein Reigem wrote:  ===

<QUOTE>Godfrey,



The way I read your posting you want to replace the whole content of an edit table with the whole content of another edit table. You also seem to indicate your edit tables have the same structure. So I don't understand why you use a loop instead of just getting and setting the whole content in one go using the ARRAY or LIST properties? Unless I got something wrong, which is very likely.



- Oystein -



</QUOTE>

----

=== At 24 MAY 2002 03:30PM Godfrey Farrugia wrote:  ===

<QUOTE>Oystein, that's exactly what I'm doing already via the Get_Property (ARRAY of one table) and then Set_Property (ARRAY of adjacent table with contents of previous Get_Property table). This is done in one FOR ... NEXT loop for several tables side-by-side, but as I said, I'd like to improve performance.



BTW, ideally, tables should inherit from one another not just the contents but also any colors existing in different cells since these indicate various conditions. However, since I'm under the impression that a Set_Property will erase any existing colors, I can live with this although it would be nice to retain them along with the table contents during the whole operation.



</QUOTE>

----

=== At 24 MAY 2002 09:31PM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>It will be quicker to just change the size properties to move them. 



You'll obviously need to juggle a bit but the basic idea is sound.



[url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url]

[url=http://www.sprezzatura.com/cebit.htm" onMouseOver=window.status= Celebrate CeBIT with GREAT offers on consultancy, programming and training';return(true)][i]Celebrate CeBIT with Sprezz Local![/i][/url]

[img]http://www.sprezzatura.com/bitzz.gif[/img]

</QUOTE>

----

=== At 24 MAY 2002 09:49PM Richard Bright wrote:  ===

<QUOTE>You mentioned a for...next loop for the get_properties to get the array of multiple tables.



Where possible you should try and get / set multiple arrays at the same time - as in one Get_Property - just delim each value by @RM, likwise for set_property.



Richard Bright

</QUOTE>

----

=== At 24 MAY 2002 10:27PM Oystein Reigem wrote:  ===

<QUOTE>Godfrey,



Right. I thought you set one row at a time or something. The window I saw before my inner eye had only 3 edit tables. You obviously have lots of the evil buggers. I don't envy you.



Now for more stupid questions: Are the edit tables all in synch? In case why don't you have just one big edit table? Well, I guess they're not in synch. :-)



Usually when I have problems with keeping property values, like you might have with cell colour, I use a user-defined property to back up the problematic one.



- Oystein -



</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=7AA8A7BC97FB63A688256BC30037E2D3|View this thread on the  forum...]]