Hello.
Taking into an account the nature of your queries, I can forward you to
these links:
http://dev.mysql.com/doc/refman/5.0/en/query-speed.html
http://dev.mysql.com/doc/refman/5.0/en/limit-optimization.html
If some of your fields have only two values ('Yes', 'No') you can
switch to ENUM
Sorry guys,
here is a table description, query and result:
SHOW CREATE TABLE Properties;
Properties |CREATE TABLE `Properties` (
`Property_ID` int(11) NOT NULL auto_increment,
`Insertion_Date` date default NULL,
`Status` varchar(20) default NULL,
`Uploader_ID` int(11) default NULL,
`Ap
Hello.
You will get much more help from the list if you provide the current
table structure, short description of the information which is stored
in that fields, and the query you want to optimize (most probably it
takes much more time than others).
> If point 1 is true then is there a way to tri
Ok this works on myisam tables, but what about InnoDB
On Fri, 22 Mar 2002, Egor Egorov wrote:
> Date: Fri, 22 Mar 2002 15:38:03 +0200
> From: Egor Egorov <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Optimizing tables
>
> Vijay,
> Friday, March 22, 2002, 1:14:33 PM, you wrote:
>
> V>
Hi,
What about taking a look at the manuel before ? ;)
http://www.mysql.com/doc/
Regards,
Jocelyn Fournier
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 22, 2002 12:14 PM
Subject: Optimizing tables
>
>
