Not signed in (Sign In)

SkillShare - A place to discuss Web Standards and Web Design topics

Categories

Vanilla 1.1.5a is a product of Lussumo. More Information: Documentation, Community Support.

Content Management Systems: MySQL Optimization Question about COUNT and SELECT

Bottom of Page

1 to 1 of 1

  1.  
    • CommentAuthorMatt
    • CommentTimeJul 12th 2007 edited
     permalink
    I have an index running on my varchar column in my table and was wondering if it is better to use the COUNT() function when selecting or to use SELECT LIMIT 1 if all I really need to do is see if the new data exists in the table already before adding it. Thanks in advance.

1 to 1 of 1

  1.  
Add your comments
    Username Password
  • Format comments as (Help)
 
Back to Discussions Top of Page