Revolution Live conference: Trevor DeVore
sunshine at public.kherson.ua
Sun Mar 23 05:08:55 EDT 2008
On 3/22/08 9:38 PM, "Trevor DeVore" <lists at mangomultimedia.com> wrote:
> This year I will be trying something different and will focus on
> issues involved with building database applications in Revolution. I
> will be talking about issues my company has had to tackle while
> working on our own products. I feel this will be much more interesting
> and instructive. There will also be code kitchens this year so we can
> help folks with their specific needs during those.
> That being said, I don't think I will be covering the query builder. I
> have never found a use for it when buildling apps myself so I don't
> have any experience with it. There is a "Lightning-fast Database
> Processing" on the schedule right now. Perhaps it will be covered there.
If you want consider Valentina, I will suggest try to touch such features as
** Valentina Studio **
* Query Builder - we have implement in Valentina very powerful Query
Builder that allow you design graphically SQL query then test it against
Currently Valentina Query Builder is analog of MS SQL
Enterprise Manager, but additional it supports some unique
Future we will improve it to support query types, which even MS SQL
do not support, e.g. OUTER JOINS, UNIONS, ...
** Valentina Engine Features **
* Usage of SQL Binding
"SELECT ... FROM T WHERE fld = :1"
this feature may give speed up for apps up to 20 times
because when you use it you get FIXED form of SQL query,
so Valentina engine is able to reuse it many times from
the pool of queries. As result no need parse it each time.
* Stored Procedures
feature useful for many cases. For example
a) it can a lots speed up in client/server mode
b) you move more logic inside of DB, so if you develop application
in Revolution AND e.g. PHP or REALbasic or NET you get
huge benefit having code inside of db, then having it 2 or more
times in each programming language.
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
[I feel the need: the need for speed]
More information about the Use-livecode