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
Hi,
I am trying to optimize my data and am currently looking at indexes etc.
Someone has suggested the following as well:
1. Ensure that there is no whitespace at the beginning or end of entries
2. Use 1 or 0 instead of yes or no.
If point 1 is true then is there a way to trim all whitespace da
spiros wrote:
Any tips for optimization?(I assume this should not be done with pure sql
statements).
It almost sounds like you might not have a very good table design to
work with, depending on what your data is. Can you describe in some
more detail what is being dealt with here?
--
Micha
In case anyone has done this before, I'd appreciate any tips for
optimizing a link analysis application , e.g in its simplest form if we have
one or more tables of the form
AB
===
a1 b1
a2 b1
a3 b2
a1 b4
a4 b1
a5 b3
a6 b2
b1 b3
b3 a2
are there any tips f
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:
Vijay,
Friday, March 22, 2002, 1:14:33 PM, you wrote:
V> how do i optimize mysql tables
I think chapter 4.4.6.10 Table Optimization in
MySQL manual will be useful for you. Look at:
http://www.mysql.com/doc/O/p/Optimisation.html
V> vijay
--
For technical support contracts, goto htt
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: Optim
Placed At : MAA
Vijay T@SATYAM
03/22/2002 04:44 PM
Hi
how do i optimize mysql tables
vijay
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
10 matches
Mail list logo