TIP: Click on subject to list as thread! ANSI
echo: nthelp
to: Ellen K.
from: Antti Kurenniemi
date: 2003-12-10 16:27:36
subject: Re: weird SQL Server experience

From: "Antti Kurenniemi" 

"Ellen K."  wrote in message
news:s2ndtvscs200r8kq6osat1fsbdl9uj2q6j{at}4ax.com...
> There were only a few users left by that point, it was like
> 9:00 p.m., probably fewer than 20.   (During the day I
> have several hundred.)   It did take several minutes (at
> least five) to add 3 GB.

Well then 30 seconds to add 900 megs wouldn't be enough, so that's most
likely to be your users original problem.


> I'm not sure whether it already creates pages when the size of
> the data file is increased, but that would be logical, particularly
> for this type of schema which includes BLOBs.

And judging from the time it takes to enlargen the database, it probably
isn't just increasing an empty file.


Antti Kurenniemi

--- BBBS/NT v4.01 Flag-5
* Origin: Barktopia BBS Site http://HarborWebs.com:8081 (1:379/45)
SEEN-BY: 633/267 270
@PATH: 379/45 1 633/267

SOURCE: echomail via fidonet.ozzmosis.com

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.