s
> Cc: 'Dan Anderson'; Chris Elsworth; [EMAIL PROTECTED]
> Subject: Re: Questions about indexing
>
>
> Even if your database fits entirely in memory, not having indexes in
> place would not be a good idea.
>
> In an interview Monty did regarding in-memory database
theory and practice. In practice
there is.
- Yogi Berra
---
-Original Message-
From: Dan Anderson [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 1:18 PM
To: Chris Elsworth
Cc: [EMAIL PROTECTED]
Subject: Re: Questions about indexing
With such a small database it really boil
re is no difference between theory and practice. In practice
there is.
- Yogi Berra
---
> -Original Message-
> From: Dan Anderson [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 15, 2003 1:18 PM
> To: Chris Elsworth
> Cc: [EMAIL PROTECTED]
> Subject: Re: Q
> With such a small database it really boils down to just being tidy;
> you don't want indexes you're not going to use.
Well the database is going to be like 200MB and executing several
hundred queries a minute. Thus my concern about speed. Is a P4 w/ 1GB
RAM going to choke and die, or will inde
On Sun, Dec 14, 2003 at 03:53:00PM -0500, Dan Anderson wrote:
>
> I have a database I'm using for a MMORPG (well, it isn't very
> MM because I'm something of a noob), and I have a few questions about
> indexing. I am storing world data in a database. In
I have a database I'm using for a MMORPG (well, it isn't very
MM because I'm something of a noob), and I have a few questions about
indexing. I am storing world data in a database. In order to keep
everything as swift as possible, I have indexed everything. An
"Mojtaba Faridzad" <[EMAIL PROTECTED]> wrote:
> I'm learning MySQL and I got two question:
>
> 1) As I know, MySQL has a buffer to keep the last records which have
been retreived. So if I run a query two times, the second time will be
faster. How can I temporarly stop this service? because I want
"Mojtaba Faridzad" <[EMAIL PROTECTED]> wrote:
> I'm learning MySQL and I got two question:
>
> 1) As I know, MySQL has a buffer to keep the last records which have been retreived.
> So if I run a query two times, the second time will be faster. How can I temporarly
> stop this service? because I
Hi,
I'm learning MySQL and I got two question:
1) As I know, MySQL has a buffer to keep the last records which have been retreived.
So if I run a query two times, the second time will be faster. How can I temporarly
stop this service? because I want to run different queries and compare their sp
