Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009

    Cool Unanswered: select query took more time to outout result-DELAY QUERY

    CREATE TABLE `tbl_trigger` (
    `trigger_ID` int(11) NOT NULL AUTO_INCREMENT,.,.,.,.,.,) ENGINE=InnoDB

    trigger_ID in primary key and having 30 lac records.

    "select trigger_ID from tbl_trigger where trigger_ID='$parameter';"

    The query took two minute to give result what the issue behind the query?
    Advance thanks.
    Last edited by fernandodonster; 11-13-17 at 01:49.

  2. #2
    Join Date
    Oct 2007
    Provided Answers: 9
    Do you have an index created on trigger_ID?

Tags for this Thread

Posting Permissions

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