From: Adam Powell
Date: March 21 1999 8:13am
Subject: performance
List-Archive: http://lists.mysql.com/mysql/707
Message-Id: <003401be7372$c219f6a0$dc947ed4@laptop>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


Eurhg, this is kind of an emergency....

If you had an IP field that had to be inserted into about 40 times a
second... what would be the best way to do it?  I have currently...

mysql> describe last_seen;
+--------+-----------------+------+-----+---------+-------+
| Field  | Type            | Null | Key | Default | Extra |
+--------+-----------------+------+-----+---------+-------+
| ip     | char(16) binary | YES  |     | NULL    |       |
| banner | char(21)        | YES  |     | NULL    |       |
+--------+-----------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

Does this look as optimised as it can get or am I doing something wrong, as
its causing the server load to be extraordinarily high.

Thanks,
Adam


-----Original Message-----
From: Sasha Pachev <sasha@stripped>
To: mysql@stripped <mysql@stripped>
Date: 21 March 1999 05:52
Subject: Performance comparison/benchmarks


>I am looking for performance comparision data for the following ways to
>run a Web application interfacing with MYSQL:
>
>regular C/C++ CGI
>C/C++ Fast CGI
>PHP
>Java Servlet
>regular Perl
>mod_perl Perl
>Anything else that I have left out that you know of.
>
>Any comments, ideas, opionions, stories, and of course hard data will be
>appreciated.
>
>--
>Sasha Pachev
>http://www.sashanet.com
>
>---------------------------------------------------------------------
>To request this thread, e-mail mysql-thread706@stripped
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@stripped instead.
>For archive commands, etc, e-mail: mysql-help@stripped
>
>