Re: Shrink Express DB After Large Data Import
- From: Otis Mukinfus <phony@xxxxxxxxxxxxxxxx>
- Date: Sat, 16 Dec 2006 18:08:15 -0600
On Fri, 15 Dec 2006 20:08:00 -0800, coastaldata <coastaldata@xxxxxxxxxxxxxxxx>
wrote:
Hello, I have a small VB.Net application that I've built in VS2005 that
indexes and helps me to work with various collections of files on my network.
It works great at first, especially with small collections, but after a time,
or immediately after import of a large collection, the application becomes
unresponsive due to the size of the database and the log.
In regards to the log, I really don't need it -- I just want to slurp in my
data and run sql queries against it... the database would never need to be
recovered.
I need either VB.Net code that can perform maintenance functions on the
database, or else a way to configure the database to not store logs, or
both...
Or some other solution? Granted, this may not be the best application of SQL
server, but I need the experience with it, and it's giving me some good
insight into the types of problems and limits that these databases encounter.
Any help is greatly appreciated!
--Jon
--(CoastalData)
I'm wondering why you don't ask this question at
microsoft.public.sqlserver.server? The SQL Server expert ratio is probably much
higher there than here.
Good luck with your project,
Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com
.
- Prev by Date: Re: Shrink Express DB After Large Data Import
- Next by Date: Re: Shrink Express DB After Large Data Import
- Previous by thread: Re: Shrink Express DB After Large Data Import
- Next by thread: Re: two Windows message loops in .NET 2.0?
- Index(es):
Relevant Pages
|
