Return to BSD News archive
Path: euryale.cc.adfa.oz.au!newshost.carno.net.au!harbinger.cc.monash.edu.au!munnari.OZ.AU!news.ecn.uoknor.edu!feed1.news.erols.com!cpk-news-hub1.bbnplanet.com!cpk-news-feed4.bbnplanet.com!news.bbnplanet.com!utk.edu!not-for-mail
From: fty@hickory.engr.utk.edu (Jay Flaherty)
Newsgroups: comp.infosystems.www.misc,comp.infosystems.www.servers.unix,comp.lang.c,comp.unix.bsd.freebsd.misc,comp.unix.programmer,comp.databases,comp.databases.ms-sqlserver,comp.databases.oracle.server,comp.databases.oracle.misc
Subject: Re: Advice needed on large database project
Followup-To: comp.infosystems.www.misc,comp.infosystems.www.servers.unix,comp.lang.c,comp.unix.bsd.freebsd.misc,comp.unix.programmer,comp.databases,comp.databases.ms-sqlserver,comp.databases.oracle.server,comp.databases.oracle.misc
Date: 28 Apr 1997 13:12:04 GMT
Organization: University of Tennessee
Lines: 115
Message-ID: <5k27n4$3s4$1@gaia.ns.utk.edu>
References: <5jo09j$20o$1@news.enterprise.net> <33606e0c.3792623@news.sc.edu> <3360C0C4.31A9264B@id.dk>
NNTP-Posting-Host: hickory.engr.utk.edu
X-Newsreader: TIN [UNIX 1.3 950824BETA PL0]
Xref: euryale.cc.adfa.oz.au comp.infosystems.www.misc:49473 comp.infosystems.www.servers.unix:29271 comp.lang.c:207513 comp.unix.bsd.freebsd.misc:39863 comp.unix.programmer:53667 comp.databases:60490 comp.databases.ms-sqlserver:17739 comp.databases.oracle.server:7562 comp.databases.oracle.misc:6099
Thomas Lund (lund@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@hickory.engr.utk.edu
------visualize whirled peas------
**********************************************