Skip to content
    hello techo

    hello techo

    post-echo dev team tech insights

    • Home
    • Coding
    • Database
    • Sys Admin
    • Strategy
    • Design
    • echo

    Category: Database

    • Home
    • Database
    Database

    Optimize MySQL Queries By Using BETWEEN Instead of LIMIT and OFFSET

    July 26, 2015July 26, 2015 Doli Stepniewski

    Using BETWEEN instead of LIMIT and OFFSET proved to be a simple optimization to a troublesome slow MySQL query.

    Read More
    Coding Database Sys Admin

    How Sphinx’s Multi-Valued Attributes Replaces the Need for an OR Comparison Operator

    May 23, 2015May 23, 2015 Doli Stepniewski

    Sphinx documentation doesn’t give examples nor explain how to use SOURCE-TYPE ‘field’ with Multi-Valued Attributes (sql_attr_multi). After experimenting, I discovered that a simple comma delimited list of ids populated in the the referenced field of my record_sphinx_index table does the trick!

    Read More
    Database

    MySQL Tip: Drop All Tables (With PostgreSQL Bonus)

    November 5, 2010November 16, 2010 Dale Liszka

    Certain DBALs and ORMs don’t provide a functional reset method to clear out schema cruft before rebuilding tables (I’m looking at you, Django).  Others like

    Read More
    Coding Database

    Zend_Test: Dealing with Dates

    October 21, 2010October 23, 2010 Anton Visser

    I have been writing a lot of integration tests lately and wanted to share a quick tip about how to deal with datetime and timestamp columns in the table you are testing.

    Read More
    Database

    MySQL Quick Tip

    October 8, 2010October 8, 2010 Brett Garland

    If you need to monitor a MySQL server in order to see what is happening, but you haven’t developed any monitoring solutions you can use

    Read More

    Posts navigation

    1 2 Next

    Fellow Techos

    • Anton Visser (9)
    • Brett Garland (1)
    • Charlie Palmer (3)
    • Dale Liszka (3)
    • Doli Stepniewski (12)
    • Paul Shoemaker (1)
    • Ted Parton (4)

    All Rights Reserved 2022.
    Proudly powered by WordPress | Theme: Fairy Dark by Candid Themes.