how can i execute a silent installation of mysql for windows?
Thanks a lot for your time.
David Tomás Fargas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
the explain of this sentence shows that mysql uses temporary tables, and
this was slow (think about the sentence only takes one record in his Limit
Clause)
of course all the fields used in relations and orders in the sentence are
primary keys.
SELECT CPOSTAL.* FROM CPOSTAL left JOIN PROVINCI ON
ra: 'David Tomàs Fargas'
Asunto: RE: Dificult question.
Have you created indexes on that table?
Regards,
Gary Huntress
Code 4113
Naval Undersea Warfare Center
Newport, RI 02841
1-800-669-6892 x28990
-Original Message-----
From: David Tomàs Fargas [mailto:[EMAIL PROTECTED]]
S
I Have a large table with 59.000 records and if i execute a simple select
since "Select * from table order by cod" it takes 4 seconds to process
query!
and if table will have 590.000 then... well, you see it.
It's possible to accelerate it, without where and limit clausules?
I think no, and in m
I Have a large table with 59.000 records and if i execute a simple select
since "Select * from table order by cod" it takes 4 seconds to process
query!
and if table will have 590.000 then... well, you see it.
It's possible to accelerate it, without where and limit clausules?
I think no, and in m
