Bloating Problem

[Guest]

Does Microsoft have any plans to fix the bloating problem?

I have tried all suggestions without impact on the bloating (Close
recordsets explicitly, create an external database, etc).


Thanks

Ross

 

[Joseph Meehan]

Does Microsoft have any plans to fix the bloating problem?

I have tried all suggestions without impact on the bloating (Close
recordsets explicitly, create an external database, etc).


Thanks

Ross

I assume you are compacting the database?

 

[aaron.kempf]

their plan to fix the bloating is to move to SQL Server lol

 

[Guest]

I knew it!

 

[Guest]

My Code rich programs start at 200K and will corrupt before processing is
complete!

Yes I compact at any point that I can.

 

[aaron.kempf]

what do you mean?

it starts at 200MB and it wont' process because it hits 2gb?

you need to use less temp tables then man.

anything this large; you really should be in MSDE or SQL Server 2005
Express edition.. there is new article about using SQL 2005 Express
with vb6-type stuff.. so im pretty sure that you could even use it with
most of your existing code..

what type of data do you have in your db

SQL Server-- MSDE--- is 10x faster with a high record count like this.
If you know how to use it. I really reccomend Analysis Services for
anything this large; it just cuts down on a lot of problems to do it
right.

what do you have a 200mb file of?

does this link to a dozen other 1gb databases and you get performance
problems because you're trying to make 4gb of temp tables?

how many records altogehter-- are getting shipped into all of your temp
tables?

why are you using temp tables

just give us a lot more information; and we'll work this out.