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)
character set from latin1 to latin2 [to proper use Polish
characters in sorting for example]?
with regards
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
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]
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
:
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
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
. 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
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
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
`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
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
12 matches
Mail list logo