Re: Perfomance Problems

--- Manuel Duran Aguete <mdaguete@alsernet.es> wrote:
> The B app takes less than a second in process each message.
>         The statement is
>         SELECT * FROM table_a
>         WHERE number = 123
>                 AND msg_orig = 'A'
>         ORDER by id;

If number is a VARCHAR then why are you selecting it like it is
an INT ("WHERE number = 123" rather than "WHERE number =
'123'")?  You seem to need an index on number.  The index on
time_b does not look like it is necessary.

Brent



__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com