[symfony-users] Re: Mysql query performance from PHP vs Mysql Client
Thanks for the response. I do realise this. What I saw was the moment mtop reported the query as running on mysqld. The time it took after interacting with the application until the query was shown as running and the time it took after the query finished to the results actually displaying on screen was negligible. My concern is that the time it takes a query generated from symfony (or PHP, I am not saying its just symfony) and showing in mtop seems to always be a lot longer thanthe same query run directly on the server via the mysql command line client. Gareth On Thu, Mar 26, 2009 at 3:52 PM, Thomas Rabaix thomas.rab...@gmail.comwrote: [I suppose you are using an ORM] ORM executes pre and post actions while quering the database. Of course these actions can slow down the all application. More over you can have models which perform sub actions while being hydrated. On Thu, Mar 26, 2009 at 2:30 PM, Gareth McCumskey gmccums...@gmail.comwrote: Greetings all, I had an interesting observation which I was hoping someone might be able to answer. Maybe I am deluding myself but what I have seen is difficult to just dismiss outright. I run a pretty complex, multi-join query in a symfony application we are building and in investigating its performance (or lack thereof) I was watching the mtop view of the query running to see in an obviously very qualitative way, where the bottleneck was; the query itself or the post-processing once the DB server has returned the results to the application and needs to be processed for display (i.e query vs propel). What I noticed was that as soon as mtop reported the query as finished that my browser display almost immediately returned the view that had to be generated from it. In other words, the post-processing seemed to be negligible and the application was performing admirably. It looked as if the query itself was the bottleneck. So I decided to run the query directly in the mysql command line client so that I could test a few things like using EXPLAIN etc. And here is where I discovered an oddity. Running the query via the application, it would take, as far as mtop said, up to 30 seconds to complete. Running the exact query in the mysql client (copy and paste from logs) resulted in a query of a few seconds. And no this was not due to caching. I ran the tests one after the other for the application and then the mysql client and turned caching off, with the app consistently taking a lot longer than the direct query run. Is there anyone out there that would know of any potential performance impact when the mysql server recieves a query via another application vs directly through its client? Is it purely because of transferring data back to a calling app causing the excess delay? And lastly, are there any settings that can help alleviate such an issue if it exists? My google searches have turned up nothing. Gareth -- Thomas Rabaix http://rabaix.net --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: Why should I write queries like this?
Just thought I would mention. Propel uses standard SQL. If you are attemtping to use Oracle specific SQL then it wont work. Just as if you were trying to use MySQL only SQL (like the MATCH keyword for a full text indexed column) it wont work because that is not standardised SQL. On Fri, Mar 27, 2009 at 3:51 AM, yunhui song songyunhui2...@gmail.comwrote: I'm using propel in our ptoject. questions here: 1.can not process oracle sequence 2.when insert oracle date type,SQL wrong 3.paging SQL is much slower than straight SQL Sign. I expect to save my time,but I have spend much more time than just SQL way! On 3/26/09, Fási Gábor maerl...@gmail.com wrote: On Thu, Mar 26, 2009 at 09:31, Benjamin agtle...@gmail.com wrote: Lets say I change a field called name to first_name. Then I rebuild the models. fooPeer::NAME will no longer exist. Do I then manually define that constant in a peer class? Nope, you can use the phpName attribute for fields, not only for tables. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: Select a column
Hi,
Using this i can get specified no of columns,but using this is it
possible to access method of class of that table or not.
Thanks,
Kusum
On Mar 25, 11:37 pm, Sid Bachtiar sid.bacht...@gmail.com wrote:
You said:
I want to select data from a table list.I want to select all rows
and only one column from this table
If you want objects, you have to select all columns, not just one.
On Wed, Mar 25, 2009 at 11:34 PM,kusumkusumdhin...@gmail.com wrote:
Hi,
This will give me a resultset object not array of objects of that
table.I want to get array of objects of that table, so i can use
methods of that class.Is it possible.
Thanks,
Kusum
On Mar 24, 4:48 pm, Dheeraj Kumar Aggarwal dheerajcom...@gmail.com
wrote:
hi
if you are using Propel1.3 then try this because Propel 1.3 now works on
PDO
$c = new Criteria();
.
.
.
.
$c-clearSelectColumns();
$c-addSelectColumn(SomePeer::SOME_COLUMN);
$stmt = MyModelPeer::doSelectStmt($c);
$results = array();
while($row = $stmt-fetch(PDO::FETCH_NUM))
{
$result[ ] = $stmt-fetchColumn(0);
}
hope this should work for u
On Tue, Mar 24, 2009 at 4:57 PM, Sid Bachtiar
sid.bacht...@gmail.comwrote:
Try something like this:
$c = new Criteria();
$c-clearSelectColumns();
$c-addSelectColumn(SomePeer::SOME_COLUMN);
$rs = MyModelPeer::doSelectRS($c);
while ($rs-next())
{
echo $rs-get(0); // value of SOME_COLUMN
}
On Tue, Mar 24, 2009 at 11:51 PM,kusumkusumdhin...@gmail.com wrote:
Hi,
I want to select data from a table list.I want to select all rows
and only one column from this table using symfony api method.How we
can select only one column.
Thanks,
Kusum
--
Blue Horn Ltd - System Development
http://bluehorn.co.nz
--
Regards,
Dheeraj
--
Blue Horn Ltd - System Developmenthttp://bluehorn.co.nz
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
[symfony-users] ExtJS Plugin version
Hi all, I have been looking at using the ExtJS library as a part of our future web applications with symfony and found that there was a plugin for symfony, sfExtjs2Plugin . One potential problem I noted was that it is listed as for symfony 1.0. Is there any word on whether a symfony 1.1 version is available or if this plugin will work as is for symfony 1.1? Gareth --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: Symfony Batch script + Emails + Request Parameters...
Hi, I am sending emails via a batch script. I need to send parameters to the email module via request params or attributes... It sends the data but gives warnings like - PHP Notice: Undefined index: REQUEST_URI in /usr/share/php/symfony/ request/sfWebRequest.class.php on line 384 Notice: Undefined index: REQUEST_URI in /usr/share/php/symfony/ request/ sfWebRequest.class.php on line 384 PHP Notice: Undefined index: SERVER_PORT in /usr/share/php/symfony/ request/sfWebRequest.class.php on line 406 On Mar 26, 4:31 pm, Sumedh sumedh.inam...@gmail.com wrote: Hi Friends, I am using Symfony 1.0. This is a problem discussed in other places on the forum but I didn't get a concrete answer... I am sending emails via a batch script. I need to send parameters to the email module via request params or attributes... It sends the data but gives warnings like - PHP Notice: Undefined index: REQUEST_URI in /usr/share/php/symfony/ request/sfWebRequest.class.php on line 384 Notice: Undefined index: REQUEST_URI in /usr/share/php/symfony/request/ sfWebRequest.class.php on line 384 PHP Notice: Undefined index: SERVER_PORT in /usr/share/php/symfony/ request/sfWebRequest.class.php on line 406 And so on... This happens because there is no http request for CLI... So, how can I overcome this problem? How do I define another environment like 'batch' and still use sfRequest class for sending and receiving parameters? I can of course put everything in DB and then fetch it back in the mail module...but that's convoluted... --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] batch script+send email+request parameter
Hi, I am sending emails via a batch script. I need to send parameters to the email module via request params or attributes... It sends the data and mail is gong proper but gives warnings like - PHP Notice: Undefined index: REQUEST_URI in /usr/share/php/symfony/ request/sfWebRequest.class.php on line 384 Notice: Undefined index: REQUEST_URI in /usr/share/php/symfony/ request/ sfWebRequest.class.php on line 384 PHP Notice: Undefined index: SERVER_PORT in /usr/share/php/symfony/ request/sfWebRequest.class.php on line 406 Thanks, Kusum --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Unchecked check boxes
http://iamcam.wordpress.com/2008/01/15/unchecked-checkbox-values/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Unchecked check boxes (Apologies for the double post.)
Apologies for the double post. I accidentially hit return before I had finished: I am reading a dynamic form with a bunch of check boxes on it. It would make my task so much easier if the unchecked fields got posted with false or null values. The common workaround for this is a hidden input tag with the same name: http://iamcam.wordpress.com/2008/01/15/unchecked-checkbox-values/ But in symfony you can't have 2 form widgets with the same name on the schema... So is there a way to ensure that unchecked check boxes still submit a value with symfony? Thanks for any help. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] jQuery + prototype problem
Hi.
i have forum :
?php echo form_remote_tag(array(
'update' = 'wall',
'url' = 'wall/addcomment',
'before' = if(!\$F('comment')){return false;},
'complete' = $('comment').value='';
)) ?
it was working fine. But after i install jQuery it is not working anymore as
Ajax!
Before, it brings result in ajax and updates wall div. But now, it goes to
wall/addcomment not bringing result!
___
Yahoo! Türkiye açıldı! http://yahoo.com.tr
İnternet üzerindeki en iyi içeriği Yahoo! Türkiye sizlere sunuyor!
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
[symfony-users] Re: jQuery + prototype problem
You probably need to use the jQuery.noConflict() function, as both libraries
are trying to use $, and colliding with each other. I put it in my page
header. Then you'll have to use jQuery() instead of $() for any jOuery
based functions you run.
Dean
_
From: symfony-users@googlegroups.com [mailto:symfony-us...@googlegroups.com]
On Behalf Of Guychmyrat Amanmyradov
Sent: Friday, March 27, 2009 9:10 AM
To: symfony-users@googlegroups.com
Subject: [symfony-users] jQuery + prototype problem
Hi.
i have forum :
?php echo form_remote_tag(array(
'update' = 'wall',
'url' = 'wall/addcomment',
'before' = if(!\$F('comment')){return false;},
'complete' = $('comment').value='';
)) ?
it was working fine. But after i install jQuery it is not working anymore as
Ajax!
Before, it brings result in ajax and updates wall div. But now, it goes to
wall/addcomment not bringing result!
_
Yahoo! Türkiye açıldı!
Haber, Ekonomi, Videolar, Oyunlar hepsi Yahoo! Türkiye'de!
www.yahoo.com.tr http://tr.yahoo.com/ /font
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
[symfony-users] Re: jQuery + prototype problem
Great tip!
I encountered this problem too and in the end I gave up and either use
one or the other.
2009/3/28 Dean Farrell dfarr...@horizon-research.com:
You probably need to use the jQuery.noConflict() function, as both libraries
are trying to use $, and colliding with each other. I put it in my page
header. Then you'll have to use jQuery() instead of $() for any jOuery
based functions you run.
Dean
From: symfony-users@googlegroups.com [mailto:symfony-us...@googlegroups.com]
On Behalf Of Guychmyrat Amanmyradov
Sent: Friday, March 27, 2009 9:10 AM
To: symfony-users@googlegroups.com
Subject: [symfony-users] jQuery + prototype problem
Hi.
i have forum :
?php echo form_remote_tag(array(
'update' = 'wall',
'url' = 'wall/addcomment',
'before' = if(!\$F('comment')){return false;},
'complete' = $('comment').value='';
)) ?
it was working fine. But after i install jQuery it is not working anymore as
Ajax!
Before, it brings result in ajax and updates wall div. But now, it goes to
wall/addcomment not bringing result!
Yahoo! Türkiye açıldı!
Haber, Ekonomi, Videolar, Oyunlar hepsi Yahoo! Türkiye'de!
www.yahoo.com.tr/font
--
Blue Horn Ltd - System Development
http://bluehorn.co.nz
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
[symfony-users] Re: jQuery + prototype problem
You can not use JQuery and Prototype at the same time. All the
library's use one component of JS and they can not both use it at the
same time. Unfortunately you can only use one at a time
-
Nathan Rzepecki
http://www.lionslair.net.au
Sid Bachtiar wrote:
Great tip!
I encountered this problem too and in the end I gave up and either use
one or the other.
2009/3/28 Dean Farrell dfarr...@horizon-research.com:
You probably need to use the jQuery.noConflict() function, as both libraries
are trying to use $, and colliding with each other. I put it in my page
header. Then you'll have to use jQuery() instead of $() for any jOuery
based functions you run.
Dean
From: symfony-users@googlegroups.com [mailto:symfony-us...@googlegroups.com]
On Behalf Of Guychmyrat Amanmyradov
Sent: Friday, March 27, 2009 9:10 AM
To: symfony-users@googlegroups.com
Subject: [symfony-users] jQuery + prototype problem
Hi.
i have forum :
?php echo form_remote_tag(array(
'update' = 'wall',
'url' = 'wall/addcomment',
'before' = if(!\$F('comment')){return false;},
'complete' = $('comment').value='';
)) ?
it was working fine. But after i install jQuery it is not working anymore as
Ajax!
Before, it brings result in ajax and updates wall div. But now, it goes to
wall/addcomment not bringing result!
Yahoo! Türkiye açýldý!
Haber, Ekonomi, Videolar, Oyunlar hepsi Yahoo! Türkiye'de!
www.yahoo.com.tr/font
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
[symfony-users] Re: jQuery + prototype problem
Yes, even if it is possible, it is still much better to use either,
not both! It is confusing to use both.
But still a great tip in case you have to use both.
On Sat, Mar 28, 2009 at 10:35 AM, Nathan Rzepecki
webmas...@lionslair.net.au wrote:
You can not use JQuery and Prototype at the same time. All the library's
use one component of JS and they can not both use it at the same time.
Unfortunately you can only use one at a time
-
Nathan Rzepecki
http://www.lionslair.net.au
Sid Bachtiar wrote:
Great tip!
I encountered this problem too and in the end I gave up and either use
one or the other.
2009/3/28 Dean Farrell dfarr...@horizon-research.com:
You probably need to use the jQuery.noConflict() function, as both libraries
are trying to use $, and colliding with each other. I put it in my page
header. Then you'll have to use jQuery() instead of $() for any jOuery
based functions you run.
Dean
From: symfony-users@googlegroups.com [mailto:symfony-us...@googlegroups.com]
On Behalf Of Guychmyrat Amanmyradov
Sent: Friday, March 27, 2009 9:10 AM
To: symfony-users@googlegroups.com
Subject: [symfony-users] jQuery + prototype problem
Hi.
i have forum :
?php echo form_remote_tag(array(
'update' = 'wall',
'url' = 'wall/addcomment',
'before' = if(!\$F('comment')){return false;},
'complete' = $('comment').value='';
)) ?
it was working fine. But after i install jQuery it is not working anymore as
Ajax!
Before, it brings result in ajax and updates wall div. But now, it goes to
wall/addcomment not bringing result!
__
__
Yahoo! Türkiye açýldý!
Haber, Ekonomi, Videolar, Oyunlar hepsi Yahoo! Türkiye'de!
www.yahoo.com.tr/font
--
Blue Horn Ltd - System Development
http://bluehorn.co.nz
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
[symfony-users] Routing to different Plugins
Hi, I am trying to figure out how i can make a routing decision. E.g. I have multiple plugins which might have modules with the same name as other plugins modules. How can I route a request to a specific plugin? Example: mysymfonyapp.com/plugin1/modulename/action - should route to plugins/sfFirstPlugin/modules/modulename mysymfonyapp.com/plugin2/modulename/action - should route to plugins/sfSecondPlugin/modules/modulename I really tried to figure that out myself, but i couldn't find a solution. Thx. Best Regards, Christian -- Christian Haintz Student of Software Development and Business Management Graz, University of Technology --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: Routing to different Plugins
But how you going to enable these modules? I mean with same name... I think it's pretty common practice to prefix module names with it's plugin name to omit such collisions. Thanks. Christian Haintz wrote: Hi, I am trying to figure out how i can make a routing decision. E.g. I have multiple plugins which might have modules with the same name as other plugins modules. How can I route a request to a specific plugin? Example: mysymfonyapp.com/plugin1/modulename/action - should route to plugins/sfFirstPlugin/modules/modulename mysymfonyapp.com/plugin2/modulename/action - should route to plugins/sfSecondPlugin/modules/modulename I really tried to figure that out myself, but i couldn't find a solution. Thx. Best Regards, Christian -- Christian Haintz Student of Software Development and Business Management Graz, University of Technology --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Re: Routing to different Plugins
Well, I recently found the following in the Jobeet Tutorial which tells the same: To avoid module name collisions, it is always a good habit to prefix plugin module names with the plugin name So, i thinkg this is probably the only and the best way to handle it. Thanks, Christian On Mar 28, 2009, at 2:39 AM, Yevgeniy A. Viktorov wrote: But how you going to enable these modules? I mean with same name... I think it's pretty common practice to prefix module names with it's plugin name to omit such collisions. Thanks. Christian Haintz wrote: Hi, I am trying to figure out how i can make a routing decision. E.g. I have multiple plugins which might have modules with the same name as other plugins modules. How can I route a request to a specific plugin? Example: mysymfonyapp.com/plugin1/modulename/action - should route to plugins/sfFirstPlugin/modules/modulename mysymfonyapp.com/plugin2/modulename/action - should route to plugins/sfSecondPlugin/modules/modulename I really tried to figure that out myself, but i couldn't find a solution. Thx. Best Regards, Christian -- Christian Haintz Student of Software Development and Business Management Graz, University of Technology -- Christian Haintz Student of Software Development and Business Management Graz, University of Technology --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
[symfony-users] Backend updates to sfGuardUser resets sfGuardUserProfile and all other user relations
Using: sf 1.2.4, Propel 1.3, sfGuardPlugin 3.1.3. I've setup the standard backend administration for the sfGuardUserPlugin based on the README. I also have an sf_guard_user_profile table, also following the plugin's README. Whenever I edit an sf_guard_user entry via the backend, the user's row in sf_guard_user_profile is reset to default values. Furthermore, any other database relations associated with the user are deleted. Does anyone know why? Do I need to manually configure the backend to handle the sf_guard_user_profile relation, along with ALL other related objects??? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~--~~~~--~~--~--~---
