All this talk about DataBases

[Andre Garzia]

Chipp,

don't you fear stored procs? (does SQLite has stored procs?)

Yes, the RAM issue is very important. When we built the lexicon, we  
started with a 9 megabytes stack (due to a mistake with a background  
group by yours trully), we wondered about RAM issues. We optmized the  
stack and now I think it has couple megabytes. It's all very fast and  
we keep checking memory and cpu use on the server, we're not  
experiencing any trouble.

On the other hand, for another project we have for collecting  
statistics on multiple clients to a central server where we will use  
complex query to make sense out of raw data, we use postgreSQL.


andre


On May 30, 2007, at 12:21 AM, Chipp Walters wrote:

> For small databases, (like the simple Address Book sample), the
> embedded database/biz logic works pretty well.
>
> But for larger projects, and especially projects where you need to be
> able to provide support to many users, it's imperative to separate the
> business logic from the data. You can still do this using RunRev
> stacks, just have the stacks hold only the data, and you move it from
> card to main interface stack. Once this separation is achieved, it's
> much simpler to choose whatever format you would like to store your
> data in, be it cards, custom props, text file, SQL server, MySQL,
> altSQLite, Valentina, etc.
>
> One huge advantage of using an external databsase like SQLite is the
> ability to store data outside of RAM. HyperCard used to use a non-RAM
> based design, but Rev stores everything in RAM. So, if you have an
> address book which has 100,000 records in a single stack, then all the
> records would need to be stored in RAM simultaneously, creating
> performance problems.
>
> Plus, there are a number of huge advantages of using real databases.
> Concurrent users, real transaction management, stored procs, etc..
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution