problem with queries

2004-12-20 Thread DeRyl
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)

how to proper set latin2 character set?

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

Re: ORDER by date: reverse order

2004-11-05 Thread DeRyl
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 write such query? TH

error with phpMyAdmin and MySQL 4.1.7

2004-11-03 Thread DeRyl
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]

proper index creating

2004-10-27 Thread DeRyl
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

2004-10-27 Thread DeRyl
: 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.mysql.com

Re: help with proper conditions and indexes needed

2004-10-27 Thread DeRyl
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: help with proper conditions and indexes needed I really

question about indexes

2004-10-26 Thread DeRyl
. 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 unsubscribe:http

Re: question about indexes

2004-10-26 Thread DeRyl
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] Sent: Tuesday, October 26, 2004 6:17 PM Subject: Re

great problem with questions

2004-09-23 Thread DeRyl
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

Re: great problem with questions

2004-09-23 Thread DeRyl
`klientid` (`klientid`) ) TYPE=MyISAM; --- Darek - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: DeRyl [EMAIL PROTECTED] Sent: Thursday, September 23, 2004 1:19 PM Subject: Re: great problem with questions * DeRyl I have database with 30 tables [some

Re: great problem with questions

2004-09-23 Thread DeRyl
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