On Fri, Apr 17, 2009 at 4:18 PM, Gilbert M. Hale <mrgmh...@rochester.rr.com> 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 _______________________________________________ Post Messages to: ProFox@leafe.com 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/c4313dbe0904171453g2bb5cf16v2bbde4d562587...@mail.gmail.com ** 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.
