Re: Which is faster when deleting rows? In() or Separate Delete stmts?

Hi mos wrote: If I have a large table with 20 million rows, is it going to be faster to use one delete statement like: delete from mytable where rcdid in(20,300,423, 9) to delete 10-100 random records using the primary index "RcdId" or should I use separate delete statements for eac

Re: Which is Faster

Dear Hayan, > Which of the following SQL queries is faster and better > "select thefield from thetable group by thetable" > Or > "select distinct thefield from thetable"? > and WHY? =if you use the MySQL command line to issue a query, a summary report follows any output giving number of rows a

Re: Which is Faster

At 04:21 AM 2/5/2002 , you wrote: >Dear all, >Which of the following SQL queries is faster and better >"select thefield from thetable group by thetable" >Or >"select distinct thefield from thetable"? >and WHY? > >Best Regards >Hayan Hayan, I believe the "Select Distinct.." gets translate

Re: Which is Faster

Dear Hayan, > Which of the following SQL queries is faster and better > "select thefield from thetable group by thetable" > Or > "select distinct thefield from thetable"? > and WHY? =if you use the MySQL command line to issue a query, a summary report follows any output giving number of rows a

Re: Which is faster VarChar(255) or Text?

On Fri, Jan 25, 2002 at 09:42:07AM -0600, BD wrote: > > Jeremy, > > Thanks, I hadn't thought of TinyText. With flat file type > databases that I used to use, if I put something in a memo field, it > takes longer to retrieve the data because it is stored in a separate > physical file. Th

RE: Which is faster VarChar(255) or Text?

ED] Subject: Re: Which is faster VarChar(255) or Text? At 02:31 AM 1/25/2002 , you wrote: >On Thu, Jan 24, 2002 at 05:27:18PM -0600, BD wrote: > > > I will be putting variable length text into a field (up to 255 > > characters but typically around 60 characters) and wonder what makes

Re: Which is faster VarChar(255) or Text?

At 02:31 AM 1/25/2002 , you wrote: >On Thu, Jan 24, 2002 at 05:27:18PM -0600, BD wrote: > > > I will be putting variable length text into a field (up to 255 > > characters but typically around 60 characters) and wonder what makes > > for faster retrieval? Or does it matter? A field defined as > >

Re: Which is faster VarChar(255) or Text?

On Thu, Jan 24, 2002 at 05:27:18PM -0600, BD wrote: > I will be putting variable length text into a field (up to 255 > characters but typically around 60 characters) and wonder what makes > for faster retrieval? Or does it matter? A field defined as > Varchar(255) or Text? Do you mean VARCHAR(25