Hi all,

Any response to this:
http://www.internetnews.com/dev-news...le.php/3631831

From the FA:

One performance enhancement that Lerdorf suggested based on code analysis was to use MySQL instead of PostgreSQL for the database.

"If you can fit your problem into what MySQL can handle it's very fast," Lerdorf said. "You can gain quite a bit of performance."

For the items that MySQL doesn't handle as well as PostgreSQL, Lerdorf noted that some features can be emulated in PHP itself, and you still end up with a net performance boost.

-arturo

On Sep 14, 2006, at 11:27 , Arturo Perez wrote:

> Hi all,
>
> Any response to this:
> http://www.internetnews.com/dev-news...le.php/3631831
>
> From the FA:
>
> One performance enhancement that Lerdorf suggested based on code
> analysis was to use MySQL instead of PostgreSQL for the database.
>
> "If you can fit your problem into what MySQL can handle it's very
> fast," Lerdorf said. "You can gain quite a bit of performance."
>
> For the items that MySQL doesn't handle as well as PostgreSQL,
> Lerdorf noted that some features can be emulated in PHP itself, and
> you still end up with a net performance boost.

I wasn't able to find anything the "article" worth discussing. If you
give up A, C, I, and D, of course you get better performance- just
like you can get better performance from a wheel-less Yugo if you
slide it down a luge track.

-M

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Arturo Perez wrote:

> Any response to this:
> http://www.internetnews.com/dev-news...le.php/3631831

Oh please! Can we skip this one?
Maybe on the advocacy groups, not on [GENERAL], pleeeeeze!

thanks,
bkw

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

AgentM wrote:

>
> On Sep 14, 2006, at 11:27 , Arturo Perez wrote:
>
>>
>> One performance enhancement that Lerdorf suggested based on code
>> analysis was to use MySQL instead of PostgreSQL for the database.
>
> ...If you give up A, C, I, and D, of course you get better
> performance- just like you can get better performance from a
> wheel-less Yugo if you slide it down a luge track.


ROTFL. That has got to go down as a classic quotation.


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Arturo Perez wrote:
> Hi all,
>
> Any response to this:
> http://www.internetnews.com/dev-news...le.php/3631831
>
> From the FA:
>
> One performance enhancement that Lerdorf suggested based on code analysis was to use MySQL instead of PostgreSQL for the database.
>
> "If you can fit your problem into what MySQL can handle it's very fast," Lerdorf said. "You can gain quite a bit of performance."
>
> For the items that MySQL doesn't handle as well as PostgreSQL, Lerdorf noted that some features can be emulated in PHP itself, and you still end up with a net performance boost.
>

Considering the quality piece of software that PHP is, I don't hold much
weight to his comment.

However, he does carry some umpf in certain circles. Perhaps we should
prove him wrong?

Joshua D. Drake



> -arturo
>
>


--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Alvaro Herrera wrote:
> Joshua D. Drake wrote:
>
>> However, he does carry some umpf in certain circles. Perhaps we should
>> prove him wrong?
>
> I take it you mean "oomph"?

Yeah probably

>
> Main Entry: oomph
> Pronunciation: 'um(p)f
> Function: noun
> Etymology: imitative of a sound made under exertion
> 1 : personal charm or magnetism : GLAMOUR
> 2 : SEX APPEAL
> 3 : PUNCH, VITALITY
>


--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

> I wasn't able to find anything the "article" worth discussing. If you
> give up A, C, I, and D, of course you get better performance- just like
> you can get better performance from a wheel-less Yugo if you slide it
> down a luge track.

I don't think a Yugo would give you better performance no matter what
you do

>
> -M
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>


--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

* Arturo Perez (aperez@hayesinc.com) wrote:
> Any response to this:
> http://www.internetnews.com/dev-news...le.php/3631831

Turn fsync off and try again. Don't expect your data to stay consistant
tho.

Enjoy,

Stephen

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFCagErzgMPqB3kigRAhE6AJ43dJaBPql/zPzaZfpzo2XAR7DTKQCgjxz0
Onov1Ih4/3IxnQWDkm/RhSs=
=L7SI
-----END PGP SIGNATURE-----

On Thu, 2006-09-14 at 11:40, Joshua D. Drake wrote:
> > I wasn't able to find anything the "article" worth discussing. If you
> > give up A, C, I, and D, of course you get better performance- just like
> > you can get better performance from a wheel-less Yugo if you slide it
> > down a luge track.
>
> I don't think a Yugo would give you better performance no matter what
> you do
>
> >

http://www.youtube.com/watch?v=mCkOpfLiRcA

mini on a ski jump.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

At 11:27 AM 9/14/2006 -0400, Arturo Perez wrote:

>Hi all,
>
>Any response to this:
><http://www.internetnews.com/dev-news/article.php/3631831>http://www.internetnews.com/dev-news...le.php/3631831
>

The title of the article is funny:

"Is PHP The Cure For The 'Broken' Web?"

In my opinion PHP is the main reason why so many websites, apps and servers
are broken! The other reason is probably MySQL .

To paraphrase Rasmus: PHP "is completely broken in so many ways".

PHP makes "wrong things" easy, and "right things" hard.

Evidence: "addslashes", "register_globals" and "magic quotes".

More evidence: PHP Nuke, phpBB, PDO vs PEAR DB.

Taking his advice on software is like taking a coprophagist's advice on
fine dining.

Link.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend