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 baktha.thalapathy

  1. baktha.thalapathy
    Post

    Calculate Working hours

    i have used index also In xydata->gstime, objectid, clientid are index In fm4features->Id, dataid, value are index but it will take the...
    Post by: baktha.thalapathy, May 24, 2010 in forum: Databases
  2. baktha.thalapathy
    Thread

    how to compare time row by row

    i have ouput like this 2010-05-14 16:47:04.0 2010-05-14 16:48:04.0 2010-05-14 16:49:04.0 2010-05-14 18:50:50.0 2010-05-14 18:51:50.0...
    Thread by: baktha.thalapathy, May 17, 2010, 1 replies, in forum: Programming
  3. baktha.thalapathy
    Post

    Calculating working hours

    yes the above takes so much time to execute the query, please help me how to reduce the time execution , thanks in advance
    Post by: baktha.thalapathy, May 13, 2010 in forum: Databases
  4. baktha.thalapathy
    Post

    Calculating working hours

    Please help me how to reduce execution time or any other way is there
    Post by: baktha.thalapathy, May 12, 2010 in forum: Databases
  5. baktha.thalapathy
    Post

    Calculating working hours

    b.gstime < a.gstime it's only take 40 sec here is the slowness
    Post by: baktha.thalapathy, May 11, 2010 in forum: Databases
  6. baktha.thalapathy
    Post

    Calculating working hours

    thanks for your reply I used gstime index in b-tree but nothing to happen it takes same time, If any other options is there to reduce...
    Post by: baktha.thalapathy, May 11, 2010 in forum: Databases
  7. baktha.thalapathy
    Post

    Calculating working hours

    starttime takes so much time Coalesce((SELECT MAX(b.gstime) FROM xydata b WHERE (...
    Post by: baktha.thalapathy, May 8, 2010 in forum: Databases
  8. baktha.thalapathy
    Post

    Calculating working hours

    In xydata and fm4features there are 1,00000 rows, I put index in fm4features.dadaid, fm4features.value then i run your(above) query it's also...
    Post by: baktha.thalapathy, May 7, 2010 in forum: Databases
  9. baktha.thalapathy
    Post

    Calculating working hours

    I have post explain query, show create table xydata and fm4features 1 PRIMARY <derived2> ALL 2749 100 Using temporary; Using filesort 2...
    Post by: baktha.thalapathy, May 7, 2010 in forum: Databases
  10. baktha.thalapathy
    Post

    Calculating working hours

    I have post explain query, show create xydata and fm4features 1 PRIMARY <derived2> ALL 2749 100 Using temporary; Using filesort 2...
    Post by: baktha.thalapathy, May 7, 2010 in forum: Databases
  11. baktha.thalapathy
    Thread

    Calculating working hours

    Hello, I am using the below sql query to calculate working hours. The problem which i am facing is that query is taking lot of time to...
    Thread by: baktha.thalapathy, May 4, 2010, 15 replies, in forum: Databases
  12. baktha.thalapathy
    Thread

    Calculate Working hours

    Hello, I am using the below sql query to calculate working hours. The problem which i am facing is that query is taking lot of time to...
    Thread by: baktha.thalapathy, May 4, 2010, 2 replies, in forum: Databases