Capabilities: RTF editing, Graphs, flat-file database
ambassador at fourthworld.com
Tue Jun 8 14:40:30 CDT 2004
>...when do you guys decide to use an SQL database instead of a single
> file loaded in memory of a flat-file database ?
> AFAIR, about 2 years ago, someone mentioned on the MC list using a well
> indexed flat-file DB of about 700,000 records, with no disturbing delays
> in searching & sorting...
My WebMerge product is effectively a specialized RAM-based database. It
generates static HTML pages from the exported contents of nearly any
database, spreadsheet, or other columnar data.
In the last couple years the program has become popular among affiliate
marketers, and many of these use product data feeds supplied by their
vendors. I have many customers who regularly process 50,000 records at
a time, and all I hear about it how fast it is. :)
(If you don't mind the blatant self-promotion, some of these user
comments are posted at
Given the nature of the program, I didn't really have a choice of how
the data is stored. But after honing performance over the years I've
gained the confidence to use simple blocks of text with chunk
expressions in many other apps as well, leaving things like MySQL for
multi-user databases (record-locking is a beautiful thing when you need it).
Fourth World Media Corporation
Developer of WebMerge: Publish any database on any Web site
Ambassador at FourthWorld.com http://www.FourthWorld.com
More information about the use-livecode