Re: Perfomance Problems

--- Manuel Duran Aguete <mdaguete(at)alsernet(dot)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