>I switched to a framework a few years ago and most (if not all) my multiuser programs run just fine. I have one with 50 users pounding 12 hours daily. They only reindex once a month. Data is about 6 gigs now. I'm not sure if it's just dumb luck or the framework (codemine). But I can say it works. I use to have a lot of trouble with memo tables and have just stop using them unless it is impossible to avoid.
>
>I'm hoping to slowly move to either postgres or MySQL. The real reason is not to support more users or to get stability - but to start working with Linux. I'm hoping that Postgres or MySQL will be the engine to support all my future programming and web projects.

PostgreSQL is, IMO, a better designed engine. Most features were designed in from the beginning and not added as an after thought. (Ingress came from an earlier version of PostgreSQL.) Several features that are really powerful is the ability to use more than one languge in UDFs, to inherit from other tables, and UDFs themselves. UDFs are not as powerful as Oracle's package paradigm, but the PostgreSQL UDF commands are, in many instances, indentical to Oracles.
Speed used to be a problem with PostgreSQL but it is not a problem now. Witht he latest release, 7.2, users can continue using PostgreSQL while the admin does a vacuum. In prior releases everyone had to quite PostgreSQL before the admin could do a vacuum. MySQL is good for medium to light stuff, but repeated experience has shown that it breaks down under heavy loads.
JLK



>
>My biggest complaint about VFP has been the lack of security on the tables. Several of my users discovered that word and excel could get to the tables (normally I would have thought this was a good thing) and did not use release the connections correctly. This caused me major grief in many ways.
>
>John