phpbar.de logo

Mailinglisten-Archive
Kleiner Contest;-)

Kleiner Contest;-)

Mariano Glas mysql_(at)_lists.phpcenter.de
Wed, 11 Apr 2001 09:38:42 +0200 

This is a multi-part message in MIME format.

------=_NextPart_000_00BD_01C0C26B.31F20E10
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

HP Netserver E800 256 MB RAM
SCSI
6.197 Sekunden

mariano

  ----- Original Message -----=20
  From: pbriner_(at)_bluewin.ch=20
  To: mysql-de_(at)_lists.4t2.com=20
  Sent: Tuesday, April 10, 2001 9:17 PM
  Subject: Kleiner Contest;-)



  Hi Liste=20

  Wollte einfach mal testen, wie lange es dauert 50000 Datens=E4tze in=20
  eine Mysql Datenbank zu schreiben.=20

  Auf meiner Kiste dauerte das ganze 12,623 Sekunden.=20
  Konfiguration:=20

  PIII 700=20
  256 MB Ram=20
  IDE Platte=20

  Wie lange dauert der Spass bei euch?=20


  for ($i=3D0;$i<50000;$i++)=20
  {=20
  $sqlinsert =3D "INSERT INTO tbllog (log_ip, log_browser, log_time, =
log_referer)";=20
  $sqlinsert.=3D "VALUES";=20
  $sqlinsert.=3D "('$REMOTE_ADDR', '$HTTP_USER_AGENT', '10.04.01', =
'$HTTP_REFERER')";=20

  $ins =3D mysql_query($sqlinsert,$conn);=20
  }=20

  Mal sehen, was die Hardware zur Performance beitr=E4gt ;-)=20


  Greets=20

  Pascal

------=_NextPart_000_00BD_01C0C26B.31F20E10
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>HP Netserver E800 256 MB RAM</FONT></DIV>
<DIV><FONT size=3D2>SCSI</FONT></DIV>
<DIV><FONT size=3D2>6.197 Sekunden</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>mariano</FONT></DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
  <A title=3Dpbriner_(at)_bluewin.ch=20
  href=3D"mailto:pbriner_(at)_bluewin.ch">pbriner_(at)_bluewin.ch</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3Dmysql-de_(at)_lists.4t2.com=20
  href=3D"mailto:mysql-de_(at)_lists.4t2.com">mysql-de_(at)_lists.4t2.com</A> =
</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, April 10, 2001 =
9:17=20
  PM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Kleiner =
Contest;-)</DIV>
  <DIV><BR></DIV><BR><FONT face=3Dsans-serif size=3D2>Hi Liste</FONT> =
<BR><BR><FONT=20
  face=3Dsans-serif size=3D2>Wollte einfach mal testen, wie lange es =
dauert 50000=20
  Datens=E4tze in</FONT> <BR><FONT face=3Dsans-serif size=3D2>eine Mysql =
Datenbank zu=20
  schreiben.</FONT> <BR><BR><FONT face=3Dsans-serif size=3D2>Auf meiner =
Kiste=20
  dauerte das ganze 12,623 Sekunden.</FONT> <BR><FONT face=3Dsans-serif=20
  size=3D2>Konfiguration:</FONT> <BR><BR><FONT face=3Dsans-serif =
size=3D2>PIII=20
  700</FONT> <BR><FONT face=3Dsans-serif size=3D2>256 MB Ram</FONT> =
<BR><FONT=20
  face=3Dsans-serif size=3D2>IDE Platte</FONT> <BR><BR><FONT =
face=3Dsans-serif=20
  size=3D2>Wie lange dauert der Spass bei euch?</FONT> <BR><BR><BR><FONT =

  face=3Dsans-serif size=3D2>for ($i=3D0;$i&lt;50000;$i++)</FONT> =
<BR><FONT=20
  face=3Dsans-serif size=3D2>{</FONT> <BR><FONT face=3Dsans-serif =
size=3D2>$sqlinsert =3D=20
  "INSERT INTO tbllog (log_ip, log_browser, log_time, =
log_referer)";</FONT>=20
  <BR><FONT face=3Dsans-serif size=3D2>$sqlinsert.=3D "VALUES";</FONT> =
<BR><FONT=20
  face=3Dsans-serif size=3D2>$sqlinsert.=3D "('$REMOTE_ADDR', =
'$HTTP_USER_AGENT',=20
  '10.04.01', '$HTTP_REFERER')";</FONT> <BR><BR><FONT face=3Dsans-serif=20
  size=3D2>$ins =3D mysql_query($sqlinsert,$conn);</FONT> <BR><FONT =
face=3Dsans-serif=20
  size=3D2>}</FONT> <BR><BR><FONT face=3Dsans-serif size=3D2>Mal sehen, =
was die=20
  Hardware zur Performance beitr=E4gt ;-)</FONT> <BR><BR><BR><FONT =
face=3Dsans-serif=20
  size=3D2>Greets</FONT> <BR><BR><FONT face=3Dsans-serif=20
size=3D2>Pascal</FONT></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_00BD_01C0C26B.31F20E10--

---
*** Weitere Infos zur Mailingliste und MySQL unter http://www.4t2.com/mysql

php::bar PHP Wiki   -   Listenarchive