>>>>> "matt" == matt thomson <[email protected]> writes:

    matt> Usually, if a table is going to be this big and queried a
    matt> lot, I will put an index on the columns that are
    matt> queried. However, as well as being read from frequently, the
    matt> table is also being written to frequently. As indexes take
    matt> time to update on write, then updating the index constantly
    matt> might end up slowing the table down so much that this method
    matt> is not scalable.

This is really a non-problem, unless you approach the size of
Facebook.


--
All the best,

Berend de Boer


          ------------------------------------------------------
          Awesome Drupal hosting: https://www.xplainhosting.com/

Attachment: pgpyd88I1_ttu.pgp
Description: OpenPGP Digital Signature

Reply via email to