That URL doesn't seem to me to be saying anything about a news server. If we
are supposed to follow one of the links on that page perhaps you could give
us a clue as to which one please?
Tim Ward
Brett Ward Limited - www.brettward.co.uk
-Original Message-
From: Simon Green [mailto
Tim Ward
Brett Ward Limited - www.brettward.co.uk
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 12 July 2002 11:17
To: Tim Ward
Subject: Re: RE: SELECT performance
Your message cannot be posted because it appears to be either spam or
simply
- MyODBC works fine for me,
then link the tables you want.
Tim Ward
Brett Ward Limited - www.brettward.co.uk
---
On August 5th ip.access will be moving to:
CPC1 Telephone: +44 (0) 1223 219000
Capital Park Fax
. The
database won hands down on all counts.
Tim Ward
Brett Ward Limited - www.brettward.co.uk
---
On August 5th ip.access will be moving to:
CPC1 Telephone: +44 (0) 1223 219000
Capital Park Fax: +44 (0) 1223 219099
a million files in the same
directory, 'cos I've tried it, but it's not terribly practical as some
operations start taking tens of minutes instead of tens of milliseconds.
Really one of the reasons for using a DBMS is to handle all this storage
management crap for you, no?
Tim Ward
Brett Ward Limited
From: Simon Ashby [mailto:[EMAIL PROTECTED]]
Sent: 01 July 2002 10:58
To: MYSQL
Subject: Speed issue
Any pointers on how to get rid of the disk churning and get a normal
response in this set up would be much appreciated.
Turn off OBDC logging.
Tim Ward
Brett Ward Limited
the different way I had to do things I was used to doing in Access.
Tim Ward
Brett Ward Limited - www.brettward.co.uk
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
SELECT table1.col_name
FROM table1 LEFT JOIN tablse2
ON table1.col_name = tablse2.col_nmae
WHERE tablse2.col_nmae IS NOT NULL
?
Tim Ward
Brett Ward Limited - www.brettward.co.uk
-Original Message-
From: Inbal Ovadia [mailto:[EMAIL PROTECTED]]
Sent: 22 May 2002 16:00
To: [EMAIL
? With proper indexes and so on the whole thing should
surely be under a second? (Of course if you've got more than four or five
levels it could be your organisation structure that's broken:-).)
Tim Ward
Brett Ward Limited - www.brettward.co.uk
-Original Message-
From: Hathaway, Scott L [mailto
From: Jerry [mailto:[EMAIL PROTECTED]]
Does anyone know of a good color coded SQL editor for MySQL that
works in Windows?
Visual Studio? You get keywords in blue, anyway.
Tim Ward
Brett Ward Limited - www.brettward.co.uk
Try ...
If ($result = ...)
{ ...
...
} else echo(mysql_error());
I always do querying like this anyway (without the error echo in live stuff
obviously)
Tim Ward
Internet Chess www.chessish.com http://www.chessish.com
--
From: Daniel Negron/KBE [SMTP
records but don't sort past the first letter then
SELECT ..., LEFT(lastname, 1) AS lastname_first ... ORDER BY
lastname_first or you might even be able to do ... ORDER BY
LEFT(lastname, 1) you'll have to experiment with that one.
Tim Ward
Internet chess www.chessish.com http://www.chessish.com
12 matches
Mail list logo