question about indexes

rement]? 2. how to optimize search speed? client table contains about 120 records disctionaries from 300 to 25 records what can I write more to better problem describe? regards DeRyl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: question about indexes

ybe is better way to sort searched data [sort wastes always a lot of time, but in this case it must be used]? does anybody have a better idea? regards DeRyl - Original Message - From: <[EMAIL PROTECTED]> To: "DeRyl" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>

proper index creating

table_tbl t where condition 1... condition 2... condition x... order by tablefieldsort1 desc tablefirldsort2 asc my question is: what indexes must be created to be used in order by clause? they must speed up search and order by ... with regards DeRyl -- MySQL General Mailing List For list

help with proper conditions and indexes needed

: klientid wojewodztwoid all these indexes are just "index" type [not unique or full...] how to correct interpret these explains and how to correct this? with regards DeRyl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Re: help with proper conditions and indexes needed

correction so I think I don't understand that and I decided to write to the list with respect DeRyl - Original Message - From: <[EMAIL PROTECTED]> To: "DeRyl" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, October 27, 2004 3:53 PM Subject: Re

error with phpMyAdmin and MySQL 4.1.7

51 installed [windows 2000, php 5] when I earlier installed MySQL 5 beta it worked good... what's wrong and how to correct this? with regards DeRyl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ORDER by date: reverse order

write: order by date desc DeRyl - Original Message - From: "Jerry Swanson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 05, 2004 8:00 PM Subject: ORDER by date: reverse order I want to sort by date but the last date appears first. How to

how to proper set latin2 character set?

character set from latin1 to latin2 [to proper use Polish characters in sorting for example]? with regards DeRyl

problem with queries

hello All, can anybody tell me how to correct this problem: 1. I use queries like that: select /*! SQL_BUFFER_RESULT */ klient.logo, klient.klientid, klient.klientnazwa, klient.struktura, concat(kodpocztowy,' ',miejscowosc) miasto, aparatnumer, concat(ulicaskrot,' ',ulicanazwa,' ',posesja) ulica,

great problem with questions

hello, I have database with 30 tables [some have over 2000k some other over 4000k rec] when I want to run a sql with a few conditions the answer is dramatically slow [over 70 seconds!] sql-s with one condition usually works well.. how is the corrcet way to optimize the database and sql question

Re: great problem with questions

entulicaid` int(11) default NULL, KEY `klientulicaid` (`klientulicaid`), KEY `klientid` (`klientid`) ) TYPE=MyISAM; --- Darek - Original Message ----- From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "DeRyl" <[EMAIL PROTECTED]> Sen

Re: great problem with questions

The first thing to notice: "Using temporary"... this is to be avoided, if possible. ## how is the correct way to avoid that? The first table read is klientslowo based on the criteria klientslowo.klientslowo LIKE 'sam%'. Is this a reasonable approach to solving the query, giving your knowledge of