Using SQL views to access variable values

Hi,

The retrieval of variable values using epdm API is very time consuming, We have been trying to make our application more efficient by querying the sql database but this also is quite time consuming when one needs to retrieve multiple variables. We have been trying out using sql views but are interested in knowing if anyone has experience using SQL views to enable quick retrieval of variable values of files in the EPDM vault.

Thank you,

Tammy

SolidworksSolidworks Pdm enterprise Pdm