Is like that much faster than =? If so, this would be a good thing to know. I'm
assuming that not putting a % either before or after the variable would make it the
equivilent of an =.
Can you possibly point me somewhere that explains this a bit or possibly gives some
kind of benchmarks?
Tha
>
>
>
>
> And I've filled this with a bit of data. Well, more than a bit - 5,791,651 rows
>actually. Still, while this is large, it doesn't seem rediculously huge.
>
> Let's say I want to perform a query
On Fri, Mar 16, 2001 at 12:32:37AM +1030, Dan Makovec wrote:
> Hi all,
>
> I'm having problems getting reasonable speed queries from a simple table.
>
...
> I've created a simple table that contains stock exchange data, as follows:
>
> CREATE TABLE shares (
> date date DEFAULT '-00-00' NO
Hi all,
I'm having problems getting reasonable speed
queries from a simple table.
First, a little info about my server
setup:
From mysqladmin version:
mysqladmin Ver 7.11 Distrib 3.22.27, for
-free
