Re: slow queries on large syslog table

--- colm ennis <colm.ennis@eircom.net> wrote:

>
> im not using the -B option so i guess im using the3 default
> number/size
> buffers.

That is the number one thing you can do to help.
The default buffer size is 64 * 8K = 0.5M. Half
a megabyte is pretty darm small.  Try going to 100Mb
and see what hapens.  Thats a 500x increase.

=====
Chris Albertson
  Home:   310-376-1029  chrisalbertson90278@yahoo.com
  Cell:   310-990-7550
  Office: 310-336-5189  Christopher.J.Albertson@aero.org

__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com