Char vs. Integer indexes for memory based databases

2001-01-16 Thread Anthony Cooke
> From: "Yury V. Bukhman" <[EMAIL PROTECTED]> > Organization: Danforth Plant Science Center > Date: Tue, 16 Jan 2001 16:49:09 -0800 > To: Anthony Cooke <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: Char comparisons vs. Integer. > > &g

FW: 2 questions!

2001-01-15 Thread Anthony Cooke
From: Anthony Cooke <[EMAIL PROTECTED]> Date: Mon, 15 Jan 2001 10:33:05 -0400 To: Arthur Radulescu <[EMAIL PROTECTED]> Subject: Re: 2 questions! Two answers! 1. Answer: Read "Chapter 12.6: Other optimization tips". In essence let the file system cache image files, st

FW: mySQL performance

2001-01-15 Thread Anthony Cooke
Hello Michael, We used to handle around that much traffic a few months back. Our setup consists of a MySQL backend with a mod_perl/PHP Apache front end. All our pages have dynamic content and are built on the fly. Right now we have a dedicated server with DellHost (D-3200) and it doesn't eve

3.23.29a - Can't create HEAP table in .INI file

2001-01-15 Thread Anthony Cooke
in memory. Found it odd because the same query works fine in 3.23.23. As such I went back to .23. The .INI file is straightforward: use motor; drop table f_datos; create table f_datos type=heap select * from datos; Any insights appreciated. Regards, Ant