Re: How to copy with large user running concurrently?
Posted in 2004
Just something silly, but if it's a logged data base have you got a fast
way to change tapes (or whatever medium you're using) when the logs fill
up and have you got
set isolation to committed read;
set lock mode to wait;
on all the tables you're going to be accessing?
roger huang wrote:
>Dear all,
> I have a SUN host ,F12000, 4cpu, 4 GB ram, running IDS 7.3 and it
>servers about 100 users at regular time and working fine. Now that We
>have a plan to open to the public for query and inserting data for a
>few days, and there will be more than 50 thousands peoples come in at
>the same time, and insert data concurrently. I am scared that the
>system will crash or what, I can't image what will it happen at that
>time.
>I don't want to cost much more money to scale up my host, because It
>last only for a few days. Is anyone can help me through this
>cheaperly?
>
>