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
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
