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. >

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 not

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 it.

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 > Su

Re: InnoDB Tables/Databases

2001-10-05 Thread Tonu Samuel
On Mon, 2010-10-04 at 19:32, Deryck Henson wrote: > 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

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 w

Re: InnoDB Tables/Databases

2001-10-04 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

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. 'sea

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. Danie

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