I try to explain my situation:
server Linux, database on mysql, tables with a lot of records (about
800.000) and with some keys (ad es. Key_1, Key_2, ...);
each key is composed by more fields (for example: Key_2 = field7, field8,
I should extract a lot of records, by ODBC, using VisualBasic
(example : "select field2, field3, field25 from table1 where field7 = 'aaa'
field8= 'bbb' ")
mysql should use Key_2 and so the query should be fast
The real result is that the query is made correctly but the speed is very
I think that you should know that the number of records that satisfy my
query is about 120.000
are there any advice to obtain more human speed ?
Thanks in advance to everybody, Sam