RE: Which is better

2011-08-02 Thread David Lerer
l.com Subject: Re: Which is better On 8/2/2011 02:41, Adarsh Sharma wrote: > Dear all, > > Just want to know which join is better for querying data faster. > > I have 2 tables A ( 70 GB ) & B ( 7 MB ) > > A has 10 columns & B has 3 columns.Indexes exist on both tables'

Re: Which is better

2011-08-02 Thread Shawn Green (MySQL)
On 8/2/2011 02:41, Adarsh Sharma wrote: Dear all, Just want to know which join is better for querying data faster. I have 2 tables A ( 70 GB ) & B ( 7 MB ) A has 10 columns & B has 3 columns.Indexes exist on both tables's ids. select p.* from table A p, B q where p.id=q.id or select p.* fro

Re: Which is better

2011-08-02 Thread Prabhat Kumar
h.sha...@orkash.com] > Sent: Tuesday, August 02, 2011 12:12 PM > To: mysql@lists.mysql.com > Subject: Which is better > > Dear all, > > Just want to know which join is better for querying data faster. > > I have 2 tables A ( 70 GB ) & B ( 7 MB ) > > A has 10 columns &a

RE: Which is better

2011-08-01 Thread Shafi AHMED
I hope the former better. Test with query plan output, though Best Rgs, Shafi AHMED -Original Message- From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com] Sent: Tuesday, August 02, 2011 12:12 PM To: mysql@lists.mysql.com Subject: Which is better Dear all, Just want to know which

Which is better

2011-08-01 Thread Adarsh Sharma
Dear all, Just want to know which join is better for querying data faster. I have 2 tables A ( 70 GB ) & B ( 7 MB ) A has 10 columns & B has 3 columns.Indexes exist on both tables's ids. select p.* from table A p, B q where p.id=q.id or select p.* from table B q , A p where q.id=p.id Thank

Re: which is better long rows in table or two short row tables

2006-07-13 Thread Miles Thompson
At 08:54 AM 7/13/2006, abhishek jain wrote: Dear Friends, I was to create a site with quite some heavy mySQL database. I wanted to know which is better longer rows in a table or two short rows tables. When compared in terms of speed etc. Pl. help me , with this question and any other tip you

Re: which is better long rows in table or two short row tables

2006-07-13 Thread Brent Baisley
y, July 13, 2006 7:54 AM Subject: which is better long rows in table or two short row tables Dear Friends, I was to create a site with quite some heavy mySQL database. I wanted to know which is better longer rows in a table or two short rows tables. When compared in terms of speed etc. Pl. hel

which is better long rows in table or two short row tables

2006-07-13 Thread abhishek jain
Dear Friends, I was to create a site with quite some heavy mySQL database. I wanted to know which is better longer rows in a table or two short rows tables. When compared in terms of speed etc. Pl. help me , with this question and any other tip you may find can be useful to me. Thanks, Abhishek

Re: Database design, which is better

2004-01-26 Thread Mike
>I have an question about the design of a database. What is the best way >to design tables. Is it better to create many small tables, or create >fewer big tables. Which of those two options will get the best performance? If you are asking whether to store the data all in one big table or a bunc

Re: Database design, which is better

2004-01-26 Thread Jochem van Dieten
Alex croes said: > I have an question about the design of a database. What is the best > way to design tables. Is it better to create many small tables, or > create fewer big tables. Which of those two options will get the > best performance? Don't worry about performance. If performance is real

Database design, which is better

2004-01-26 Thread Alex croes
I have an question about the design of a database. What is the best way to design tables. Is it better to create many small tables, or create fewer big tables. Which of those two options will get the best performance? TIA, Alex Croes -- MySQL General Mailing List For list archives: http://list

Re: Which is better: big SQL statement or bigger db?

2003-07-02 Thread Jon Haugsand
* [EMAIL PROTECTED] > Case A: ... > This statement would probably be much larger (upto 150 lines) and would > query one table without additional joins. > > Case B: > > Here, when a user enters a city, the soundex of it is created and then > queries a table that contains every city in the db PLUS al

Re: Which is better: big SQL statement or bigger db?

2003-07-02 Thread Armand Turpel
Hi, May the following sql statement is more efficient. SELECT * FROM bc_posts WHERE post_citysoundex IN('A265','A415',.) Armand motorpsychkill wrote: I need to have a user input a city and have MySQL pull up any records with that city OR nearby cities (within 10 mi). Which of the following

Which is better: big SQL statement or bigger db?

2003-07-02 Thread motorpsychkill
I need to have a user input a city and have MySQL pull up any records with that city OR nearby cities (within 10 mi). Which of the following would be the most efficient way to do this: Case A: When a user enters a city, an array of nearby cities is created so that an SQL statement like the follo

Re: Newbie question: Which is better InnoDB or BDB?

2002-05-27 Thread Benjamin Pflugmann
Hello. On Thu, May 23, 2002 at 11:53:49AM -0400, [EMAIL PROTECTED] wrote: > Hello, > I'm new to MySql. I plan to switch my Java/JDBC web application to use > MySql. The application requires transactions so, as I understand it, I need > the table types to be BDB or InnoDB. Can anyone offer comment

Newbie question: Which is better InnoDB or BDB?

2002-05-23 Thread Richard Davidson
Hello, I'm new to MySql. I plan to switch my Java/JDBC web application to use MySql. The application requires transactions so, as I understand it, I need the table types to be BDB or InnoDB. Can anyone offer comments on which file type is preferred? Is one more stable than another? Is there a sign

My sql queries...Which is better??

2001-06-03 Thread VVM Ravikumar Sarma Chengalvala
Hi, I am using my sql CAPI.I am able to access the database well but there is one performance issue that came into my mind. Is it better to have a single query on multiple tables using joins? (OR) Multiple queries without joins on each table,in a sequential order . If I use jo

Re: Table Design -- which is better?

2001-02-23 Thread Jason Landry
Have you considered using the SET datatype? It would be perfect for your situation. - Original Message - From: "Nino Skilj" <[EMAIL PROTECTED]> To: "'Tbone'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, February 23, 2001 7:38

RE: Table Design -- which is better?

2001-02-23 Thread Atle Veka
- > From: Tbone [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 23, 2001 4:18 PM > To: [EMAIL PROTECTED] > Subject: Re: Table Design -- which is better? > > > Hi, > How would the data look a like. > And how about the query's > > Greetz Tbone > ---

RE: Table Design -- which is better?

2001-02-23 Thread Nino Skilj
The data would be 1's and 0's (on/off) Nino -Original Message- From: Tbone [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 4:18 PM To: [EMAIL PROTECTED] Subject: Re: Table Design -- which is better? Hi, How would the data look a like. And how about the query'

Re: Table Design -- which is better?

2001-02-23 Thread Tbone
Hi, How would the data look a like. And how about the query's Greetz Tbone - Original Message - From: "Nino Skilj" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 24, 2001 12:17 AM Subject: Table Design -- which is better? > I have a g

Table Design -- which is better?

2001-02-23 Thread Nino Skilj
I have a general design question. Is it better to design one table with 45 columns or to split it into 3 tables with 15 columns each. There would be about 5000 rows in the table and it would be used more for reading rather than writing. I'm new to this, is there anything I'm missing? Thanks, N