|
Course
VIII - Programming with the In-Memory Driver 2.0 Templates
and Classes
Learn
how to get the most performance from your applications using
the In-Memory Driver Templates and the new Classes available
in version 2.0. Learn to specify advanced options for loading
and saving In-Memory data, work with BLOBs, SQL and more.
You'll learn to squeeze every drop of performance from this
powerful tool.
|
Module
|
Topic
Outline
|
|
The
In-Memory Templates
This section of the course leads you through each of the template
options, and into the mehtods available in the associated
class.
|
- In Memory Cached Table Support
- Its primary function is to create and build a memory
table without the need for any hand code to load
and use the In-Memory table. You can optionally
save the contents of the cached memory table to
the original data source.
- Generated
Memory Tables
- By
definition, a generated
IMDD table is one that is generated automatically
by the IMDD template and the underlying
- FileSynchronization class library. Also by default, the generated table
is filled (or loaded) at program start up. Typically
you will be using In-Memory tables to cache data
for fast lookups, and to improve performance on
complex reports, but if you do allow updates to
your IMDD tables learn how the Template also provides
the option to write data from the Memory table back
to the original physical file.
- Dictionary
Memory Tables
- Dictionary
Tables in
the In-Memory Caching
Support extension allow you to match a target
data source (like a TopSpeed, Btrieve, or MS-SQL
table) with an IMDD table defined in your data dictionary.
- Load
and Save Code Templates
- The
InMemoryCachedtableLoad
and InMemoryCachedtableSave code templates are used with any Dictionary
cached table.
- The
interface is very simple, but the power behind them
is not. You'll learn how to get the most out of
these templates.
|
Beyond
the Templates
Practical
examples using the IMDD around custom source code.
|
- Using
Triggers with the IMDD
- Using
the IMDD to "denormalize" tables
- Storing
IMDD record snapshots into a BLOB
- Using
the IMDD to process an SQL result set
- Maintaining
multiple tables with a Single IMDD table
|
Memory
Tables in BLOBs
A
look at using BLOBs to snaphot and restore In-Memory
tables.
|
Need to save a snapshot of a memory table, store it in
a permanent data source, and recall it when needed?
The answer lies in the use of a BLOB.
-
BLOBTODATAFILE ( )
-
DATAFILETOBLOB ( )
|
Memory
Tables and SQL
If you are now using Clarion 6.2 with the IMDD Version
2.0, you now have a more powerful tool for processing
any type of SQL queries into a result set that can
easily be processed by the In-Memory Database Driver.
|
Lean how to process any type of SQL queries into a result
set that can easily be processed by the In-Memory Database
Driver. |
Additional
content
|
Using
Flash movies, self-tests and clearly written commentary
the course guides you through example applications, and
the code used to get the best pefromance from your applications.
Topics include building multi-dll applications that use
the In-Memory driver, the use of Triggers, and the IMDD
synchronization class. |
|
