Re: [PERFORM] MySQL HandlerSocket - Is this possible in PG?

2011-01-09 Thread Dimitri Fontaine
Michael Ben-Nes mich...@epoch.co.il writes: I wonder if PostgreSQL should replicate this functionality somehow. How can I represent this idea to the developers? They will probably know if this feature worth something. As I didn't have enough time to follow this thread in detail I'm not sure

Re: [PERFORM] MySQL HandlerSocket - Is this possible in PG?

2010-12-22 Thread Pierre C
Do you mean I should use PREPARE? Currently I use PHP to access the DB which use libpq. Is that cosidered a fast call API ? if not, can you please refer me to the right info. PHP pg_pconnect command open a persistent PostgreSQL connection. Is it enough or I better use PgPool2 or something

Re: [PERFORM] MySQL HandlerSocket - Is this possible in PG?

2010-12-22 Thread Scott Marlowe
On Tue, Dec 21, 2010 at 2:09 AM, Michael Ben-Nes mich...@epoch.co.il wrote: Hi, Just stumbled on the following post: http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-story-for.html The post claim that MySQL can do more qps then MemCahed or any other NoSQL when doing

Re: [PERFORM] MySQL HandlerSocket - Is this possible in PG?

2010-12-22 Thread Marti Raudsepp
On Tue, Dec 21, 2010 at 11:09, Michael Ben-Nes mich...@epoch.co.il wrote: Just stumbled on the following post: http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-story-for.html The post claim that MySQL can do more qps then MemCahed or any other NoSQL when doing simple

Re: [PERFORM] MySQL HandlerSocket - Is this possible in PG?

2010-12-22 Thread Pierre C
On Wed, 22 Dec 2010 14:17:21 +0100, Michael Ben-Nes mich...@epoch.co.il wrote: Thanks, it is most interesting -- Michael Ben-Nes - Internet Consultant and Director. http://www.epoch.co.il - weaving the Net. Cellular: 054-4848113

Re: [PERFORM] MySQL HandlerSocket - Is this possible in PG?

2010-12-22 Thread Michael Ben-Nes
I think this might be a game changing feature. For the first time after 10 years I have reason to consider MySQL, as the cost per performance in such scenario is amazing. Morever I wont have to run it in single mod or loose other functionality by using this feautre. as I can access the ordinary

[PERFORM] MySQL HandlerSocket - Is this possible in PG?

2010-12-21 Thread Michael Ben-Nes
Hi, Just stumbled on the following post: http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-story-for.html The post claim that MySQL can do more qps then MemCahed or any other NoSQL when doing simple queries like: SELECT * FROM table WHERE id=num; And I wonder if: 1.

Re: [PERFORM] MySQL HandlerSocket - Is this possible in PG?

2010-12-21 Thread Pavel Stehule
Hello you can emulate it now. a) try to do a simple stored procedure, where you can wrap your query b) use a FAST CALL API to call this procedure c) use a some pool tool for pooling and persisting sessions Regards Pavel Stehule 2010/12/21 Michael Ben-Nes mich...@epoch.co.il: Hi, Just

Re: [PERFORM] MySQL HandlerSocket - Is this possible in PG?

2010-12-21 Thread Pavel Stehule
2010/12/21 Michael Ben-Nes mich...@epoch.co.il: Hi Pavel, Thanks for your quick answer. Can you please elaborate a bit more about the points bellow. On Tue, Dec 21, 2010 at 1:31 PM, Pavel Stehule pavel.steh...@gmail.com wrote: Hello you can emulate it now. a) try to do a simple stored

Re: [PERFORM] MySQL HandlerSocket - Is this possible in PG?

2010-12-21 Thread Merlin Moncure
On Tue, Dec 21, 2010 at 10:50 AM, Pavel Stehule pavel.steh...@gmail.com wrote: 2010/12/21 Michael Ben-Nes mich...@epoch.co.il: Hi Pavel, Thanks for your quick answer. Can you please elaborate a bit more about the points bellow. On Tue, Dec 21, 2010 at 1:31 PM, Pavel Stehule

Re: [PERFORM] MySQL HandlerSocket - Is this possible in PG?

2010-12-21 Thread Michael Ben-Nes
Hi Pavel, Thanks for your quick answer. Can you please elaborate a bit more about the points bellow. On Tue, Dec 21, 2010 at 1:31 PM, Pavel Stehule pavel.steh...@gmail.comwrote: Hello you can emulate it now. a) try to do a simple stored procedure, where you can wrap your query Do you