1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Recent Content by sc_king

  1. sc_king
    Thread

    proper cookie checking for seo

    Hi, This is what i have for cookie checking. setcookie("mycookie", "my value", "", "/"); header("Location:...
    Thread by: sc_king, May 11, 2010, 0 replies, in forum: Programming
  2. sc_king
    Post

    Order by in derived table slow

    Hey Koko, Thanks for the reply. It takes the same amount of time on all the fields. Even if I order by id and that's the primary key....
    Post by: sc_king, Jan 28, 2010 in forum: Databases
  3. sc_king
    Post

    Order by in derived table slow

    Anybody have any ideas on this issue?
    Post by: sc_king, Jan 28, 2010 in forum: Databases
  4. sc_king
    Thread

    Order by in derived table slow

    Hi guys, I'm not sure what's going on with the order by. The order by name below takes .14 seconds. Without it, it takes .0054 seconds. select...
    Thread by: sc_king, Jan 27, 2010, 3 replies, in forum: Databases
  5. sc_king
    Post

    Help optimize a query

    Hey guys, As far as i know mysql doesn't really optimize your queries, maybe the more powerful ones but I could be wrong. I will look into...
    Post by: sc_king, Jan 23, 2010 in forum: Databases
  6. sc_king
    Post

    Help optimize a query

    Hey koko, Thanks for the reply again. The IN with 2000 ids seems slow compared to the left joins. my .3 second query turned into a .8 second...
    Post by: sc_king, Jan 23, 2010 in forum: Databases
  7. sc_king
    Post

    Help optimize a query

    Is there a way I can use limit $a offset $b on the stars so i won't have to use the whole table? Problem that comes along is that if the star...
    Post by: sc_king, Jan 22, 2010 in forum: Databases
  8. sc_king
    Post

    Help optimize a query

    CREATE TABLE `picturesets` ( `id` int(11) NOT NULL auto_increment, `title` varchar(500) NOT NULL, `description` varchar(1000) NOT NULL,...
    Post by: sc_king, Jan 22, 2010 in forum: Databases
  9. sc_king
    Post

    Help optimize a query

    Hi koko, thanks for the reply. let's say if i inner join stars and movies, if the star has no movies the star will be lost before i can inner...
    Post by: sc_king, Jan 22, 2010 in forum: Databases
  10. sc_king
    Thread

    Help optimize a query

    Hi guys, My query grabs the total movies and pictures which are currently out for a certain gender. I only display stars that have at least 1...
    Thread by: sc_king, Jan 21, 2010, 11 replies, in forum: Databases
  11. sc_king
    Post

    Default count(*) to 0

    Hi, select * from companies LEFT JOIN (select company_id, count(*) from parts group by company_id) as parts_per_company ON companies.id =...
    Post by: sc_king, Dec 28, 2009 in forum: Databases
  12. sc_king
    Thread

    Default count(*) to 0

    When left joining a count(*) to a each id, is there a way to default the count(*) to 0 instead of NULL if there are none?
    Thread by: sc_king, Dec 27, 2009, 3 replies, in forum: Databases