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
    Location
    East Lansing, MI USA
    Posts
    7,049
    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

Bookmarks

Posting Permissions

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