RE: PostgreSQL

2002-02-06 Thread Daniel Backhausen
Hi. No, Postgres has much more. The biggest point is, that it has Subselects ! But mySQL seems to be much faster in some points. That´s all I want to tell :) Greetz Daniel -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 3:59 PM To:

AW: Which Hardware do I need ?

2002-02-06 Thread Daniel Backhausen
:[EMAIL PROTECTED]] Gesendet: Montag, 4. Februar 2002 23:53 An: Daniel Backhausen Cc: mySQL Mailingliste Betreff: Re: Which Hardware do I need ? On Mon, Feb 04, 2002 at 11:55:57AM +0100, Daniel Backhausen wrote: > > Hi. > > Does somebody know which server hardware I have to buy t

AW: Which Hardware do I need ?

2002-02-06 Thread Daniel Backhausen
have momentary a DUAL 1 GHz Server with 1 GB Ram, but DB> he gets a load of 40 and restarts after some time. Tell us about the number of connections open and number of average simultaneous queries. Then we wil try to help. DB> - Daniel Backhausen -- For technical support contracts

Which Hardware do I need ?

2002-02-04 Thread Daniel Backhausen
. thx & regards - Daniel Backhausen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECT

RE: auto_increment

2002-01-07 Thread Daniel Backhausen
100, 101, 102, ... Greeting - Daniel Backhausen --- N2MEDIA web- & multimediadesign http://www.N2media.de - mailto:[EMAIL PROTECTED] -Ursprüngliche Nachricht- Von: Gesendet: Montag, 7. Januar 2002 13:25 Betreff: auto_increment Return-path: <[EMAIL PROTECTED]> Envelope-to:

AW: db and the web

2001-12-17 Thread Daniel Backhausen
Hi Frankie. Where did you created a db ? Which data will you add to your database ? A dump ? Be more specific. Greetz - Daniel Backhausen --- N2MEDIA web- & multimediadesign http://www.n2media.de - mailto:[EMAIL PROTECTED] -Ursprüngliche Nachricht- Von: Frankie Cooke [mailto:[E

AW: HELP... lot of Load !

2001-12-11 Thread Daniel Backhausen
manually to view the load gage. Greetz Daniel -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im Auftrag von Benjamin Pflugmann Gesendet: Dienstag, 11. Dezember 2001 22:04 An: Daniel Backhausen Cc: mySQL Mailingliste Betreff: Re: HELP... lot of Load ! Hi

AW: HELP... lot of Load !

2001-12-10 Thread Daniel Backhausen
27;%routenplaner%' OR Locations.Kategorien_Locations3_Name LIKE '%routenplaner%' ) AND Locations.PLZ LIKE '%' AND Locations.Ort LIKE '%%' AND Locations.Sichtbar = '1' AND Locations.Kino != '1' AND Locations.Bundesland LIKE '%%' G

AW: is type casting available

2001-12-10 Thread Daniel Backhausen
Hi. Best and simpliest way ist to use phpMyAdmin for such changes. Greetz - Daniel Backhausen -Ursprüngliche Nachricht- Von: sreedhar [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 10. Dezember 2001 12:43 An: mysql Betreff: is type casting available hi all, how can i cast a variable

AW: SELECT QUERY Problem

2001-12-10 Thread Daniel Backhausen
Hi. Try this one: SELECT MAX(score) FROM scores_1, scores_2 WHERE Id = 15 Greetz - Daniel Backhausen -Ursprungliche Nachricht- Von: Anatole [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 10. Dezember 2001 11:32 An: [EMAIL PROTECTED] Betreff: SELECT QUERY Problem Hello, I often run

AW: HELP... lot of Load

2001-12-10 Thread Daniel Backhausen
: You said that I have to look these slow queries are. Can you explain it a little bit ? I remember that joins can be very slow, and if there is an mistake in my query it can produce such a load ? Regards - Daniel Backhausen Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im Auftrag von Benjamin

HELP .. lot of load

2001-12-10 Thread Daniel Backhausen
r/com --man dir=/usr/share/man --infodir=/usr/share/info --without-debug --withou t-readline --enable-share@ --- So if somebody has an i

HELP... lot of Load

2001-12-10 Thread Daniel Backhausen
r/com --man dir=/usr/share/man --infodir=/usr/share/info --without-debug --withou t-readline --enable-share@ --- So if somebody has an i