No announcement yet.

SQL Schema Docs

  • Filter
  • Time
  • Show
Clear All
new posts

    SQL Schema Docs

    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!

    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.
    Ray Yates
    "If I have seen further, it is by standing on the shoulders of giants."
    --- Sir Isaac Newton


      ^^^ That.
      Bruce Golub
      Phosphor Media - "Your Success is our Business"

      Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook