Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: p1zza
  • Content: Threads
  • Order by date
  1. p1zza

    ORDER BY on 2M rows kills performance permanently

    i've got a table with ~2 million rows. i have a select that pulls out an int, a varchar(200) and a CHAR(8) by calculating which entry is the most out-of-date, based on an auto-updating timestamp field and a tinyint priority field. the query is: SELECT url_id, url, hash FROM url WHERE priority...
    • p1zza
    • Thread
    • Replies: 1
    • Forum: MySQL
  2. p1zza

    mysql uses alot of RAM and doesn't give it back?

    i'm using mysql 4.0.16 on a gentoo 1.4 box with a gentoo-patched 2.4.23 kernel, 1.3GHz Athlon, 512MB RAM and 20GB HD space (old hd). i boot up to commandline, login, and top shows 440MB+ of RAM free. i launch an app i've written which begins by hitting mysql with a query against a table of ~2M...
    • p1zza
    • Thread
    • Replies: 4
    • Forum: MySQL

Part and Inventory Search

Back
Top