Discussions

 View Only
  • 1.  Query Writing Best Practices

    Posted 05-24-2023 12:07

    Hello all!

    I'm looking to crowdsource best practices for query writing! I've done extensive research in the community blog posts and discussion threads and can't find more than a few basic and obvious tips and tricks...

    This question is coming up because I inherited a relatively old app, that has slowly grown into a Frankenstein mess. It now has tables with hundreds of thousands, sometimes millions, of records with weird relationships. So, I have to turn to queries -- But my queries regularly get overridden by QB and stopped, or they try to run and slow down the whole realm. FTR, I don't have access to the performance optimizer.

    Thanks!



    ------------------------------
    Harrison Ray
    ------------------------------


  • 2.  RE: Query Writing Best Practices

    Posted 05-24-2023 13:18

    When you have queries which are operating on hundreds of thousands or millions of records you are asking for trouble with Performance. I don't think they are going to be the answer to Frankenstein.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Query Writing Best Practices

    Posted 05-25-2023 15:38

    @Sharon Faust put together a handy query formula playbook. You might find it useful even if not for the Frankenstein app.

    you can get it here: https://www.quickbasejunkie.com/query



    ------------------------------
    Adam Keever
    ------------------------------