Professional Web Applications Themes

SQL Sentence count disctint - MySQL

Hi I have 1 app that always make SELECT count(DISTINCT cedula) FROM(matrix_odontograma) This is very slow in 1 MB of record, exist any way to make this more efficient ?...

  1. #1

    Default SQL Sentence count disctint

    Hi I have 1 app that always make

    SELECT count(DISTINCT cedula) FROM(matrix_odontograma)

    This is very slow in 1 MB of record, exist any way to make this more
    efficient ?

    Alejandro Guest

  2. #2

    Default Re: SQL Sentence count disctint

    Alejandro wrote: 

    Do you have an index on cedula? What datatype is it?

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  3. #3

    Default Re: SQL Sentence count disctint

    Alejandro wrote: 

    ALTER TABLE matrix_odontograma ADD INDEX (cedula)

    --
    File not found: (R)esume, (R)etry, (R)erun, (R)eturn, (R)eboot
    Pedro Guest

Similar Threads

  1. #39264 [Opn->Bgs]: Problem with IF sentence
    By derick@php.net in forum PHP Bugs
    Replies: 0
    Last Post: October 26th, 11:52 AM
  2. #39264 [NEW]: Problem with IF sentence
    By hipolitoalvarez at yahoo dot com dot ar in forum PHP Bugs
    Replies: 0
    Last Post: October 26th, 11:46 AM
  3. Sentence Drag
    By Flash_Neophyte webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: February 6th, 05:54 PM
  4. To count Words of a Sentence
    By Fredg in forum Microsoft Access
    Replies: 5
    Last Post: July 29th, 01:16 AM
  5. Sentence /paragraph spacing
    By pyrolabs webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 1
    Last Post: July 8th, 08:52 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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139