db tuning and Servoy

Let’s assume I / We have developed a very nice niche application and I / We have sold it to few customer.

After a while I / We have collected more informations on how our customers are “really” using the application and with data growth over the time some db tuning is needed. I / We have discovered some non unique indexes are basically needed to proper support the medium / long term usage of the application.

Is there any way to include definition of those indexes in the Servoy application catalog to avoid to manually recreating with a script at each customer site?
How other application developers / installers are managing such situation? Just a script manually executed after solution deployment?

Tnks a lot for any feedback.
Gianni

Hi Gianni,

this can be automated, but the SQL you need will depend on the database.
Which database are you using?

We did something you want with sybase, still need to trigger this manually: http://forum.servoy.com/viewtopic.php?f=12&t=11675