> Do those 4 gig problems = 1 massive table in the db, or are there a > few massive ones? > > Are you truncating the log file wich is part of that 4 gig limit? > > Have you made the mega tables into their own single db? I use to do > that back in the free MSDB version with 2000. That got me over that > hurdle for a while. > > You can join table between databases by including the > dbname.dbo.TableName. You don't need new connection strings to cross > dbs. >
I am not doing anything re: the SQL Server Express 2005 database they are using. I made my recommendations, yet for the production tables they insist on setting all fields to c(80), even for Numeric, Logical and DateTime values. They did finally recast the Temp tables I populate via updateable remote views within VFP to match my VFP field types, after I found that converting my various field values to character fields did indeed push two tables over 2Gb. Some tables have over 2,000,000 records, many have over 500,000 records. My tables fit well within the 2Gb limit, for obvious reasons (VFP). If, by defining all fields as c(80) in SQL Server they end up with some tables alone being over 1Gb, and they have 7 core tables to deal with, well - there just isn't a lot that can be done... Other than redefining the production table fields like I suggested, or moving to a more scalable database solution. PostgreSQL would fit perfectly for them, but they may be more receptive to ADS because it costs something, hence can be taken more seriously. But, lordy, we don't want to be taken MS SQL Server or Oracle level seriously $$$! I have made my recommendations to them from the very beginning of their data warehouse project. They will do what they want, and only made changes when I hit a 2Gb limit on the updateable views I was populating for them to process into their production tables. Horse led to water, horse did not drink, horse is wondering why it is so thirsty and wanting of "something". Gil > -----Original Message----- > From: [email protected] [mailto:profoxtech- > [email protected]] On Behalf Of Stephen Russell > Sent: Friday, April 17, 2009 5:53 PM > To: [email protected] > Subject: Re: Advantage Database and VFP > > On Fri, Apr 17, 2009 at 4:18 PM, Gilbert M. Hale > <[email protected]> wrote: > > There are some folks that do not want, or are not allowed (company > policy, > > etc.) to use anything that is Open Source. I feel Open Source > solutions are > > more likely to be more secure than commercial solutions. But I have > found > > plenty of folks that prefer to argue that point. For me, my > recommendation > > for a database that scales larger than VFP is PostgreSQL. But, given > what > > ADS offers, for folks who feel paying for a database is the better > solution, > > well, I just may have a viable, relatively lower cost alternative to > M$ SQL > > Server and Oracle. Amazingly my clients that are persistently > bumping into > > the SQL Server 2005 Express 4Gb limit are resistant to PostgreSQL. > But they > > do not want to pay for SQL Server for 3,000+ employees. So, ADS may > just be > > the ticket for them - and I can still slipstream my VFP app into the > mix to > > feed them updated data! > ---------------------------------------- > > Do those 4 gig problems = 1 massive table in the db, or are there a > few massive ones? > > Are you truncating the log file wich is part of that 4 gig limit? > > Have you made the mega tables into their own single db? I use to do > that back in the free MSDB version with 2000. That got me over that > hurdle for a while. > > You can join table between databases by including the > dbname.dbo.TableName. You don't need new connection strings to cross > dbs. > > > > -- > Stephen Russell > Sr. Production Systems Programmer > Web and Windows Development > Independent Contractor > Memphis TN > > 901.246-0159 > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
