Re: [SQL] Hardware performance for large updates

2002-09-06 Thread Josh Berkus
Joe, > I think we'd need more information to be of any help -- schema, > functions, explain output, etc. Yeah, I know. I'm just looking for general tips here ... I need to do the actual optimization interactively. Particularly, the difficulty is that this application gets many small reque

Re: [SQL] Hardware performance for large updates

2002-09-06 Thread Joe Conway
Josh Berkus wrote: > Particularly, the difficulty is that this application gets many small > requests during the day (100 simultaneous uses) and shares a server > with Apache. So I have to be concerned about how much memory each > connection soaks up, during the day. At night, the maintainence