SQL Schema Docs

[augieortiz]

I'm attempting to refactor a module but would like to rewrite by using a SQL query for better overall performance. Currently the module loops over several data objects and a SQL query with some where conditions would improve our speed.

Does anyone know where I can find a current sql schema to help better write this query. I was given old documentation by the miva team, but can't find anything for miva 10. Any help is greatly appreciated!

[RayYates]

There is a utility module on the Miva app store named Toolbelt. Along with other things it as a feature named Sherlock which lets you inspect the Miva Merchant database tables and execute SQL scripts. This is great for development where you cam fully prototype your SQL statement before putting them into you scripts. The module also has a command "Query" that lets you run the SQL statement inside your Miva Merchant page templates.

Use with caution.

[Bruce - PhosphorMedia]

^^^ That.