| TIP: Click on subject to list as thread! | ANSI |
| echo: | |
|---|---|
| to: | |
| from: | |
| date: | |
| 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™.