Bind to File Takes Too Long

[Aronax]

I have a template which runs in multiple threads and, at its end, it saves the results in a table which is binded to an xlsx file.

Before adding the line to the table I inserted a 'Bind to File' table action block because, as far as I know, this is mandatory when multiple threads are writing to the same results file.

I noticed that the bind to file takes quite long...something like 5 seconds (and the rest of the project itself takes less than 5 seconds).

The excel file has about 3.5k entries right now...and at the end of the job should have around 50k. I know that Zenno doesn't like big excel tables but splitting the table is not option for me.

What should I do? Thanks!

 

[Aronax]

I also noticed that, when running in Zennoposter, the template takes a long time before starting to load the page (like another 5 seconds).

So not the actual page loading takes too long...but Zenno just waits a few seconds before starting to load the page and in the address bar I can only see the 'about:blank' syntax).

Is this related to the large excel file or this is a different problem?

 

[rostonix]

You dont need to use bind to file option if you bind file to the same table. You can set path in table settings

 

[Aronax]

Thanks for your feedback

OK, so when the template adds a line to a table, and that table already has a path in table settings, there is no need for Bind to File.

How about when the template is reading from a table that already has a path in table settings? Is 'Bind to File' action block needed here? ('delete line after taking' option is checked)

Of course, in both situations, the template is running on multiple threads simultaneously....basically I want to avoid the situation when two or more threads are taking the same line from a single source table.

Thanks a lot, again!

 

[lokiys]

Bind to file is used for creating dynamic file paths, that mean when file path is built while template is working OR you want for example two tables to work with same file.

If you have static path and you have set it in table settings then you do not need bind to file in any way.

All will work just fine in multithreads.

 

[Aronax]

Thanks a lot! I've removed the bind to file blocks. Now the template spends a lot of time (3-4 seconds in PM) when getting/ adding a line from/ in the tables. It looks like it just cannot cope with the supposedly large size of the excel file (50 MB, 50k lines).

Any thoughts for diminishing this time?
Thanks

 

[rostonix]

Mysql databases?)