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

From: Ellen K. 

Yes, your original point was very good.   Probably it has to create the
pages and also do the housekeeping that will let it know which page is
where and what's on each one.

On Wed, 10 Dec 2003 16:27:37 +0200, "Antti Kurenniemi"
 wrote in message :

>"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™.