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
ystring("search") > > Thanx. I'm hoping to test this on my database soon (the InnoDB) > > ** > - Deryck Henson > - http://www.comp-u-exchange.com > ** > - Original Message - > From: "Deryck Henson" <[EMAIL PROTECTED]> > To: "M

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
u-exchange.com ** - Original Message - From: "Deryck Henson" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Monday, October 04, 2010 12:23 PM Subject: InnoDB Tables/Databases > OK, I will soon have a huge database, home to about 500,000,0

InnoDB Tables/Databases

2001-10-04 Thread Deryck Henson
OK, I will soon have a huge database, home to about 500,000,000+ records and believe that MySQL needs to be faster. I have heard good things about InnoDB but Ihave no idea what it is. Can someone please tell me (or give a url telling) what it is, the benifits, how I can set it up on an already e