Very Computer

Hi everybody,

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,
field9)

I should extract a lot of records, by ODBC, using VisualBasic
(example : "select field2, field3, field25 from table1 where field7 = 'aaa'
and
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
very slow
I think that you should know that the number of records that satisfy my
query is about 120.000

Request:
are there any advice to obtain more human speed ?

Thanks in advance to everybody, Sam

Hi everybody,

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,
field9)

I should extract a lot of records, by ODBC, using VisualBasic
(example : "select field2, field3, field25 from table1 where field7 = 'aaa'
and
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
very slow
I think that you should know that the number of records that satisfy my
query is about 120.000

Request:
are there any advice to obtain more human speed ?

Thanks in advance to everybody, Sam

Hi everybody,

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,
field9)

I should extract a lot of records, by ODBC, using VisualBasic
(example : "select field2, field3, field25 from table1 where field7 = 'aaa'
and
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
very slow
I think that you should know that the number of records that satisfy my
query is about 120.000

Request:
are there any advice to obtain more human speed ?

Thanks in advance to everybody, Sam

Hi everybody,

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,
field9)

I should extract a lot of records, by ODBC, using VisualBasic
(example : "select field2, field3, field25 from table1 where field7 = 'aaa'
and
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
very slow
I think that you should know that the number of records that satisfy my
query is about 120.000

Request:
are there any advice to obtain more human speed ?

Thanks in advance to everybody, Sam

Hi everybody,

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,
field9)

I should extract a lot of records, by ODBC, using VisualBasic
(example : "select field2, field3, field25 from table1 where field7 = 'aaa'
and
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
very slow
I think that you should know that the number of records that satisfy my
query is about 120.000

Request:
are there any advice to obtain more human speed ?

Thanks in advance to everybody, Sam

I would look for a more appropriate newsgroup. Maybe comp.databases.* ?

Koos Pol
----------------------------------------------------------------------
S.C. Pol                          T: +31 20 3116122
Systems Administrator             F: +31 20 3116200

Amsterdam                         PGP public key available

newsgroup mysql.general
on news.netimages.com

I should extract a lot of records, by ODBC, using VisualBasic
(example : "select field2, field3, field25 from table1 where field7 = 'aaa'
and
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
very slow
I think that you should know that the number of records that satisfy my
query is about 120.000

Request:
are there any advice to obtain more human speed ?

Thanks in advance to everybody, Sam