RawSQL flushAllClients Cache is a little slow

Classic Servoy
1

Hi,

I am cuurently using IT2BE’s data plugin to import records into a Servoy-MySQL database. Basically it inserts excel data in four related tables. I have used RawSQL plugin’s executeSQL function to do the inserts. All of this is being done using Servoy WebClient. I have used a form to upload the excel file with an import button on it. When the user presses the import button, it shows the “loading…” symbol on top right corner of the screen. I have put three flushAllClients Cache in the end of the script. My issues are:

  1. Flushing 800 or so records is taking about 8 minutes, which is quite slow.
  2. The “loading…” symbol disappears at the end of the script but I can’t close the dialog box because I think the database is still trying to flush the cache even when the script is complete. If there was some way of notifying the user while the database flushes the cache in the background and close the dialog at the end of it, that would be really good.

Please let me know if there is a solution to this problem.

Regards,
Sunil.

2

Flush all clients cache will be slow, especially if you are doing it three times.

My question is why are you using rawSQL to do the inserts? If you are reading the data from excel using the plugin, it would be better to just use a new foundset from the tables and create new records on the foundset. This would allow data broadcasting across clients to work properly. Then there would not be an issue with clearing the client’s cache, it would not be necessary.

Jason