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 order to keep
> everything as
