Thomas Lund (lund_at_id.dk) wrote:
: Vipul S. wrote:
: > =
: > check out msql. you will find the link from yahoo .
:
: Or even better (IMHO) MySQL on www.tcx.se
:
: It's faster than msql
Not only is it faster than mSQL but more robust and basically free.
check out these features:
Main features of MySQL
- Multi-threading.
- Join optimizer with one-sweep multi-join (all joins made in one
pass).
- A privilege and password system with is very flexible (the mysql
database).
- All password traffic on the net is encrypted.
- Fixed and variable length records.
- 16 keys/table. Each key may consist of 1 to 15 columns. Max key
length is 127 bytes, but may be increased to 500 by changeing one
line of source. `CREATE TABLE' supports the `PRIMARY KEY
(columns)', `INDEX (columns)' and `UNIQUE (columns)' syntaxes. A
`PRIMARY KEY' is always `UNIQUE'. A key may be a prefix of a CHAR
field.
- All columns have default values. One can always use INSERT on any
subset of columns.
- ODBC Open-DataBase-Connectivity for Windows95 (with source).
- Almost all ODBC functions (and lots of others). Functions are
implemented through a very optimized class library and should be
as fast as they can get! Usually there shouldn't be any memory
allocation after the query initialization.
- Very fast B-tree disk tables.
- In memory hash tables always used as temporary tables.
- Can handle big databases (we are using MySQL with some databases
with 50,000,000 records).
- C and Perl API (The Perl API is a superset of the mSQL Perl API).
Other languages with mSQL bindings should be simple to add
- Uses GNU autoconfig for portability.
- Written in C and C++. Tested with gcc 2.7.2.1.
- A thread based malloc system (very fast and no memory trashing).
- No memory leaks (tested with purify).
- A very fast table check and repair utility (`isamchk').
- All data saved in ISO8859_1 format. All comparisons for normal
string columns are case insensitive.
- Full ISO8859_1 (Latin1) support. For example Scandinavian \145\144\166
is allowed in table and column names.
- Sorts by ISO8859_1 Latin1 (The swedish way for the moment). It is
possibly to change this in the source by adding new sort order
arrays.
- Alias on tables and columns as in the SQL92 standard.
- Support for functions in the fields part of the select. Example
`select (column1+column2) from table'
- Support for group functions (`sum', `max', `min', `avg' & `count').
- User commands as `show tables', `show keys from table' and `show
columns from table'
- `INSERT',`UPDATE' and `DELETE' returns how many rows was affected.
- Functions names don't clash with table or column names. (For
example ABS is a valid column name). The only restriction is that
space is not allowed between a function name and the '(' when
using functions.
- Explicit test with functions `=' and `<>' to constant `NULL' is
identical as the `IS NULL', `IS NOT NULL' tests. This is an SQL
extension to be compatible with mSQL. (Of course one should use
`IS NULL'.)
- All MySQL commands have `--help' or `-?' as help.
- The server supports error messages to client's in Swedish, English
or (partly) German.
- The client uses a socket or TCP connection when connecting to
server.
Also, there is a very active user community via the MySQL listserv.
Jay (just a very happy customer of MySQL)
--
**********************************************
Jay Flaherty fty_at_hickory.engr.utk.edu
------visualize whirled peas------
**********************************************
Received on Mon Apr 28 1997 - 00:00:00 CDT
