Results 1 to 2 of 2

Thread: anything other than COUNT?

  1. #1

    anything other than COUNT?

    whenever i use the COUNT(*) function in mysql it seems to take about 5 seconds for a page to load opposed to < 1 sec. does that make any sense, and is there any alternative to the COUNT function?

  2. #2
    Administrator Chris's Avatar
    Join Date
    Feb 2003
    East Lansing, MI USA
    Is your DB properly indexed? What are you using count? Could you do it in PHP instead?
    Chris Beasley - My Guide to Building a Successful Website[size=1]
    Content Sites: ABCDFGHIJKLMNOP|Forums: ABCD EF|Ecommerce: Swords Knives

Similar Threads

  1. Local Rank stuff...
    By chromate in forum Search Engine Optimization
    Replies: 41
    Last Post: 02-07-2004, 03:53 PM
  2. overture search term count vs google ?
    By s2kinteg916 in forum Search Engine Optimization
    Replies: 1
    Last Post: 11-14-2003, 11:28 AM
  3. Does link from .edu count much more than .com domain?
    By sonnyyu in forum Search Engine Optimization
    Replies: 3
    Last Post: 08-25-2003, 01:11 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts