Be Cautious About MySQL Licensing (was Re: Database suggestions?)

[Chipp Walters]

Welcome to our list Ruslan :-)

I'm no database expert, though you can find plenty of them on the SQLite 
open source website: www.sqlite.org

I challenge you to post your benchmarks there if you're serious about 
getting a response. There you'll find more of the 'war' I believe you're 
searching for.

Though, I can point to some speed facts about the program:

 From the SQLite.org home page:

"A series of tests were run to measure the relative performance of 
SQLite 2.7.6, PostgreSQL 7.1.3, and MySQL 3.23.41. The following are 
general conclusions drawn from these experiments:

     *SQLite 2.7.6 is significantly faster (sometimes as much as 10 or 
20 times faster) than the default PostgreSQL 7.1.3 installation on 
RedHat 7.2 for most common operations.
     *SQLite 2.7.6 is often faster (sometimes more than twice as fast) 
than MySQL 3.23.41 for most common operations.
     *SQLite does not execute CREATE INDEX or DROP TABLE as fast as the 
other databases. But this is not seen as a problem because those are 
infrequent operations.
     *SQLite works best if you group multiple operations together into a 
single transaction."

I believe the absense of Valentina benchmarks only indicates they chose 
to compare against some of the more popular databases, and ones who's 
source code was 'open' for all to see.

Also, I notice you make mention of 'locking' records. If you use this 
trick for SQLite, you are adding needless cycles to the benchmark. The 
SQLite database is a 'single-user' database, and has no need for locking 
records in the Revolution environment. I would think you, as a 
proficient database expert (unlike I) would of course know this?

A last challenge: Why don't you create a great Demo for Valentina in 
Revolution? I believe if you do, you may find you can increase your 
sales and help out our community. If you're interested in viewing ours, 
please see:
http://www.altuit.com/webs/altuit2/altSQLiteCover/default.htm

Also, I noticed you're still selling Valentina for Revolution 1.1.1. 
We're now up to version 2.5.1. I know your users are eager for you to 
update!

And at $299 for both Mac and PC, that would make it 3X as expensive as 
altSQLite. And of course, altSQLite also includes Linux.

Have a nice day,

Chipp Walters
Altuit, Inc.

Ruslan Zasukhin wrote:

> :-) I think this is little a myth that SQL Lite is fast.