M!Table performance issue using SalListInsert( )

[James McCall]

 Posted by:  James McCall 

Mainly for Michael but for anyone who wishes to comment ...

This issue appears somewhere between versions 1.8.2 and 1.9.5 of M!Table.

The performance of SalInsertItem( ) on a drop down list column is severely
degraded. It is not noticable for sensible amounts of data but one of our
customers has added 3000 items to one of their lists.

On my PC (CTD2000 on Windows XP) adding 1000 items is almost instantaneous
with v1.8.2 and takes over 13 seconds with v1.9.5.

I'll attach a sample application as first response to this post along with
the 1.8.2 DLLs for M!Table (mtbl20.dll & mimg20.dll).

Regards,
James

[James McCall]

 Posted by:  James McCall 

Make a .EXE of this application and put it into a directory containing just
mtbl20.dll & mimg20.dll
Run it & click the [Go] button.
If the M!Table version is 1.8.2 then it will add 1000 list items instantly
If the M!Table version is 1.9.5 then it will take quite a few seconds

[micsto]

 Posted by:  Michael Stoll \(MICSTO\) 

Hi James,

first of all sorry for the delay, but I'm rarely looking into the old
newsgroups.
If there are any problems in the future, please send a mail to
support@micsto.com.

Found the problem and fixed the version which is currently in development
( 1.9.7 ).
The new fixed version isn't significant slower than the "old" M!Table
versions.
If you need a hotfix, please contact me via support mail (
support@micsto.com ).

BTW, the problem was "introduced" with 1.9.5 ( new function
MTblDefineCellType ), because since this version M!Table has to store the
list values of every drop down cell in an internal list. Updating this
internal list on inserting/adding values wasn't really optimal - and that
was the reason for the bad performance.

Cheers
Michael

[James McCall]

 Posted by:  James McCall 

Michael,

Thanks for taking a look at this and for the in depth explanation.

It is not urgent. I sent our customer the older DLL and it works fine for
this particular application.

Cheers,
James