Edit Table Array (OpenInsight 32-Bit) [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.
{{tag>category:"OpenInsight 32-Bit" author:"Gerry Van Niekerk" author:"dsig@sigafoos.org"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== Edit Table Array (OpenInsight 32-Bit) ====
=== At 22 JUN 2004 06:13:05PM Gerry Van Niekerk wrote: ===
 
 
<QUOTE>
v7.01



We have a calculation we do so we can populate an edit table.

26 columns

approx 1400 lines or more!



After calculating the data we then set the array of the edit table

This takes approximately 1 minute plus depending on the speed of the PC.



We also tried setting LIST, send_message(Insert)

and they all take the same amount of time.



If the number of lines in the edit table is there then it takes a few seconds, however if the lines are not in the table it takes a longggggggggg time.



Is there a way we can make this faster, as the client uses Excel and says if Excel is fast we should be able to do it quick as well.





Gerry van Niekerk

Csoft
</QUOTE>
----

=== At 22 JUN 2004 06:56PM dsig@sigafoos.org wrote:  ===

<QUOTE>Gerry,



it sounds like you are saying that if the datatable contains the data then it takes a minute. IF the data table does not contain the data it takes a long time.  Is this right?  If yes then my guess is that the additional time is being taken by reading in the data?



If this is the case then you need to come up with some creative methods of storing the data and retrieving it.  This might include alternative ways of storing the data, use of indexes etc.



Of course if my guess at what you were saying is wrong then forget what i said 



dsig@sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

[url=http://www.sigafoos.org/samweb]DSig's Radio Free Oregon[/url]

David Tod Sigafoos ~ SigSolutions

</QUOTE>

----

=== At 22 JUN 2004 07:51PM Gerry Van Niekerk wrote:  ===

<QUOTE>Not Quite,

We create the data on the fly, 

That takes a few seconds,



Because the table is not data bound, 

when you display the data ie Set_property('window.table','ARRAY',DATA)

It takes between 30 seconds and 2 minutes just to populate the table





Gerry van Niekerk

Csoft

</QUOTE>

----

=== At 23 JUN 2004 01:45AM dsig@sigafoos.org wrote:  ===

<QUOTE>hmm not even close.



I just created a new window with 2o columns and 25 rows showing.  I then wrote a little routine on the crate that simply sucked up 1200 rows and built a large list (actually concat the rows together because they are only 15 columns).  With this config it only took a few seconds to set_property LIST the data.



So I moved the row count to 5000.  There was a big difference in the amount of time, it took 31 seconds to post the data.  The size of the array was 2,513,406.



What is the size of the data you are posting?



Would it be possible to use Send_MEssage to Insert to the bottom of the table several hunks of data?  Might be faster that 1 big set_property.





Now true the data is sparse in some columns but there is a mi

dsig@sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

[url=http://www.sigafoos.org/samweb]DSig's Radio Free Oregon[/url]

David Tod Sigafoos ~ SigSolutions

</QUOTE>


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