NYCPHP Meetup

[David Mintz]

You nailed it bro. Turns out that when I was launching MysqlCC from a
shortcut on the windoze desktop, the working directory was the desktop so
it was bitching about no syntax file. I adjusted the shortcut's "Start in"
property and now mysqlcc is happy. Thanks.

On Mon, 9 Feb 2004, Tim Gales wrote:

> Try putting 'syntax.txt'
> in the directory where the
> executable exists --
> most likely place:
> C:\Program Files\mysqlcc
> > Subject: [nycphp-talk] MySQL Control Center GUI error msg
> >
> >
> >
> > mysqlcc likes to give me this error -- or perhaps, a mere
> > warning -- thus:
> >
> > Could not load Syntax File: 'C:/Documents and
> > Settings/mintzd.MINTZD/Desktop/syntax.txt'
> >
> > I've googled and browsed mysql.com/doc and come up empty. It
> > ain't the end of the world -- the tool keeps on working --
> > but it would be nice to solve this.
> >
> > Any clues?
> >
> >
> > ---
> > David Mintz
> > http://davidmintz.org/
> >
> >         "Anybody else got a problem with Webistics?" --
> > Sopranos 24:17 _______________________________________________
> > talk mailing list
> > talk at lists.nyphp.org http://lists.nyphp.org/mailman/listinfo/talk
> >
>
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk
>


---
David Mintz
http://davidmintz.org/

        "Anybody else got a problem with Webistics?" -- Sopranos 24:17

>From hans not junk at nyphp.com  Mon Feb  9 16:27:10 2004
Return-Path: <hans not junk at nyphp.com>
Received: from ehost011-1.exch011.intermedia.net (unknown [64.78.21.3])
	by virtu.nyphp.org (Postfix) with ESMTP id 98E5CA8602
	for <talk at lists.nyphp.org>; Mon,  9 Feb 2004 16:27:10 -0500 (EST)
X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: [nycphp-talk] MySQL Query Cache
Date: Mon, 9 Feb 2004 13:27:09 -0800
Message-ID: <41EE526EC2D3C74286415780D3BA9F8777249D at ehost011-1.exch011.intermedia.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [nycphp-talk] MySQL Query Cache
Thread-Index: AcPvO2BpW0UlR1SyRLSQfYosdYTFVAAF5sCA
From: "Hans Zaunere" <hans not junk at nyphp.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
X-BeenThere: talk at lists.nyphp.org
X-Mailman-Version: 2.1.2
Precedence: list
Reply-To: NYPHP Talk <talk at lists.nyphp.org>
List-Id: NYPHP Talk  <talk.lists.nyphp.org>
List-Unsubscribe: <http://lists.nyphp.org/mailman/listinfo/talk>,
	<mailto:talk-request at lists.nyphp.org?subject=unsubscribe>
List-Archive: <http://lists.nyphp.org/pipermail/talk>
List-Post: <mailto:talk at lists.nyphp.org>
List-Help: <mailto:talk-request at lists.nyphp.org?subject=help>
List-Subscribe: <http://lists.nyphp.org/mailman/listinfo/talk>,
	<mailto:talk-request at lists.nyphp.org?subject=subscribe>
X-List-Received-Date: Mon, 09 Feb 2004 21:27:11 -0000


> > I was surprised to find out this weekend that MySQL 4.x has a
built-in=20
> > query cache.
> > http://www.mysql.com/doc/en/Query_Cache_Configuration.html
>=20
> As a PostgreSQL bigot, I get similar functionality through the use of=20
> adodb; but the big difference with MySQL's caching is that MySQL is=20
> smart enough to know a cache has been affected by data updates, and=20
> rebuilds the cache - adodb is strictly time-based, but requires no=20
> round-trips to the db box.
>=20
> Out of curiosity, anyone here with strong opinions on either, and want

> to share?  I'm strictly on the fence, as I love adodb's independence
and=20
> network-friendly approach, but also love MySQL's 'refreshing'=20
> capability...

I've used MySQL query cache and it's great.  I generally have it off by
default, but then specify SQL_CACHE in SELECT statements that are
intensive.  This has given me the best of both worlds.

Lastly, I'm anti /database abstraction/client side query cache (which is
an oxymoron)/ so I won't touch on that much more :)

H