[thelist] tuning MySQL

[Pedro Arana]

On 11/28/06, Matt McKeon <matt at camadro.com> wrote:
> Hershel Robinson wrote:
> Right sorry, forgot the details in my cloud of confusion.
> MySQL v.4.1.21
> PHP v.4.4.4
>
> The two tables I'm working with are both less then 1MB, the DB size is
> only about 5MB. This PHP script/MySQL DB was working seemingly fine in
> our previous setup..
>
> The SQL being used is:
> SELECT tbl_one.id, tbl_one.rating_current, tbl_one.rating_count,
> tbl_two.name_internal
> FROM tbl_one, tbl_two
> WHERE tbl_one.id = tbl_two.id AND tbl_two.name_internal = $name
>
> UPDATE tbl_one
> SET rating_current = $rate, rating_count = $cnt
> WHERE id = $id
>
> Hope that makes it a little easier, o and its in a RHE 4 environment.
>
> -matt
> --

hi!

Wich information shows desc?

DESC SELECT tbl_one.id, tbl_one.rating_current, tbl_one.rating_count,
 tbl_two.name_internal
 FROM tbl_one, tbl_two
 WHERE tbl_one.id = tbl_two.id AND tbl_two.name_internal = $name



-- 
"La forma más rápida de lograr que un ingeniero solucione un problema
es declarar que el problema es insoluble."