Re: HT Feature

2012-04-12 Thread Johan De Meersman
- Original Message - From: Kaushal Shriyan kaushalshri...@gmail.com Any performance bottleneck if HT (Hyper Threading) is enabled in quad core processors on CentOS 5.8 running MySQL DB Server ? Please help me understand about pros and cons of this feature. That very much depends on

Re: HT Feature

2012-04-12 Thread Kaushal Shriyan
On Thu, Apr 12, 2012 at 6:38 PM, Johan De Meersman vegiv...@tuxera.bewrote: - Original Message - From: Kaushal Shriyan kaushalshri...@gmail.com Any performance bottleneck if HT (Hyper Threading) is enabled in quad core processors on CentOS 5.8 running MySQL DB Server ? Please

Re: The most elegant/efficient way to pull this SQL query

2012-04-12 Thread Hal�sz S�ndor
2012/04/11 17:51 -0500, Peter Brawley select b.peopleID, concat('(',p.fname,,')'), b.stateID, concat('(',s.state,')') from bridge b join people p on b.peopleID=p.peopleID join state s on b.stateID=s.stateID; Since the names are the same in the tables, it works to use USING, too, and you are

Re: The most elegant/efficient way to pull this SQL query

2012-04-12 Thread Haluk Karamete
My initial goal was to write a very convenient php function that display a table view based on arguments that are super simple to write - without requiring the developer to type-in ( or know ) the ins and outs of joins, natural joins etc. Something like this function

Re: The most elegant/efficient way to pull this SQL query

2012-04-12 Thread Hal�sz S�ndor
; 2012/04/12 11:56 -0700, Haluk Karamete My initial goal was to write a very convenient php function that display a table view based on arguments that are super simple to write - without requiring the developer to type-in ( or know ) the ins and outs of joins, natural joins etc. Something