Re: InnoDB Tables/Databases

2001-10-05 Thread Heikki Tuuri
Deryck, the latest information on InnoDB you can always find at http://www.innodb.com Regards, Heikki Innobase Oy Here is two thing for you. First, GREAT source for search of pass problem on any thing really. http://marc.theaimsgroup.com/ Then, information on the InnoDB. Not hard to find

Re: InnoDB Tables/Databases

2001-10-05 Thread Ilya Martynov
DO Here is two thing for you. DO First, GREAT source for search of pass problem on any thing really. DO http://marc.theaimsgroup.com/ DO Then, information on the InnoDB. Not hard to find really. DO http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#I DO nnoDB I would

RE: InnoDB Tables/Databases

2001-10-05 Thread Daniel Ouellet
Thanks you for the URL. (: I just added to my collections. Daniel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ilya Martynov Sent: Friday, October 05, 2001 04:06 To: Daniel Ouellet Cc: Deryck Henson; MySQL Subject: Re: InnoDB Tables

Re: InnoDB Tables/Databases

2001-10-05 Thread another oracle dba
Deryck, others: I'm doing some reading on InnoDB and am pretty ignorant on the subjets. Can someone explain why would InnoDB be faster than MySQL? From what I read it looks like it will have more overhead to support the transactions and that should decrease the performance rather than improve

Re: InnoDB Tables/Databases

2001-10-05 Thread Benjamin Pflugmann
Hi. Heikki, please correct me, if I say something stupid. ;-) On Fri, Oct 05, 2001 at 10:07:04AM -0700, [EMAIL PROTECTED] wrote: Deryck, others: I'm doing some reading on InnoDB and am pretty ignorant on the subjets. Can someone explain why would InnoDB be faster than MySQL? Please note

Re: InnoDB Tables/Databases

2001-10-05 Thread Tonu Samuel
On Fri, 2001-10-05 at 23:59, Benjamin Pflugmann wrote: Hi. Heikki, please correct me, if I say something stupid. ;-) On Fri, Oct 05, 2001 at 10:07:04AM -0700, [EMAIL PROTECTED] wrote: Deryck, others: I'm doing some reading on InnoDB and am pretty ignorant on the subjets. Can

Re: InnoDB Tables/Databases

2001-10-04 Thread Deryck Henson
The original query is as follows: SELECT * FROM websites WHERE category LIKE '%search%' OR keywords LIKE '%search%' OR description LIKE '%search%' The search instances are from an ASP page. 'search' is a variable that is asigned the value of the query string 'search' dim search search =

RE: InnoDB Tables/Databases

2001-10-04 Thread Daniel Ouellet
Here is two thing for you. First, GREAT source for search of pass problem on any thing really. http://marc.theaimsgroup.com/ Then, information on the InnoDB. Not hard to find really. http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#I nnoDB Have a good reading.

RE: InnoDB Tables/Databases

2001-10-04 Thread Daniel Ouellet
I love this one! (: That put a smile on a long night! Thanks! Daniel The original query is as follows: SELECT * FROM websites WHERE category LIKE '%search%' OR keywords LIKE '%search%' OR description LIKE '%search%' The search instances are from an ASP page. 'search' is a variable