similar to: How to see all queries

Hi, When writing a Rails app, what common tasks can likely result in performance issues? The one I''m aware of is something like: Model.find(:all).each do |elem| # do stuff end Especially when there''s lots of elements in the Model. What other ones are there? Also, does Rails do caching of queries? If I''m in a view and I do: <% if user.admin? %> ... and

I have: class Country < ActiveRecord::Base has_many :states has_many :cities, :through => :states has_many :places, :through => :cities end What is the query RoR is using when I type: @places = @country.places Is it only one query with joins? -- Posted via http://www.ruby-forum.com/.

Hi all, I updated rails to 1.1.2, and somehow, when I run script/server on a new rails project, I don''t see the sql queries in the console any more... It was very useful to see them live... Does any one have any idea why? Thank you very much! Nauhaie -- Posted via http://www.ruby-forum.com/.

Hi group, I was wondering if anyone more experienced could help me to find a good pattern for two things: 1. How to group controllers. Example: We have an admin panel with: user_managment_controller.rb priv_managment_controller.rb widget_controller.rb User panel with: mystuff_controller.rb mytags_controller.rb profile_controller.rb And frontend with: widget_controller.rb etc... How do I group

Hi, There is a line in acts_as_taggable plugin: send(acts_as_taggable_options[:from]).tags.find_or_create_by_name(name).on(self) could someone explain what is: send(xxx) and .on(self) I cannot find it rDoc -- Posted via http://www.ruby-forum.com/.

Hello All, Has anyone configured bri to answer for only one msn? In essence, when the primary is busy I want to have channel 2 ring. I am using an eicon diva server bri I know I saw it in the windows interface, but don't see it in the linux setup. Regards, Greg

Is there a simple way of forcing file_column to download file from given (ex. in form) url instead of uploading it manualy? I know: http://blog.caboo.se/articles/2006/01/09/file_column-magick-and-versions require ''open-uri'' Attachment.find_first.filename = open(url) if not working as expected... what is interesting is that: >> @a =

belongs_to :through Why is that not possible? We should have: Street belongs_to :city belongs_to :country, :through => :city -- Posted via http://www.ruby-forum.com/.

Hi Guys, This is something related and yet un-related to Asterisk. I have a FreePBX/Asterisk server running and I want to trace everything that FreePBX does to MySQL. Is there a verbose CLI to MySQL that I can pull up on terminal and make configuration change to FreePBX and see it in real-time on the terminal as to what is added to which MySQL table and where? Thanks -------------- next part

The is something I wrestle with a bit when I construct joined queries.. Perhaps some experienced insight will straighten this out for me. Say you have two tables with two models, ''authors'' and ''posts''. an author has_many posts, a post has_one author. You need methods to do the following queries: find_author(postid) find_posts(authorid) And you are doing a

Hello Andrew, 1. What is the explanation for the fact that when the log level is set to 5 or 7, the NT_STATUS_IO_TIMEOUT error does not appear, but when it is at the default log level, it does? Another point I've noticed before is that when I run the command "samba-tool dbcheck --cross-ncs --reset-well-known-acls --fix --yes" (*Checked 15337 objects (0 errors)*), and in another

Hello All, I have installed Shorewall 2.0.7 and configured , I am using masq to share internet for users. I have problem of perticular sites . I blocked site IP address. and succeeded but i have problem of Public proxy addresses , some user use anonymous proxy Ip and get thru it and use blocked sites. I blocked Public proxy adresses but it lot of them( I mean more than one public proxy

With good and faithful python remote database queries look something like this: url.urlopen("username/pssword at host",query) where query is something like "select * from table where ...." Does R support queries on remote hosts with username and password? What does a simple example look like? Thank you.

This change adds cainfo and capath options to the curl plugin. They refer directly to CURLOPT_CAINFO and CURLOPT_CAPATH, as documented in libcurl. Signed-off-by: Wiktor Gołgowski <wiktor.golgowski@linux.intel.com> --- plugins/curl/curl.c | 16 ++++++++++++++++ plugins/curl/nbdkit-curl-plugin.pod | 9 +++++++++ 2 files changed, 25 insertions(+) diff --git

On Thu, 2024-04-11 at 14:21 -0300, Elias Pereira wrote: > Hello?Andrew, > > 1. What is the explanation for the fact that when the log level is > set to 5 or 7, the NT_STATUS_IO_TIMEOUT error does not appear, but > when it is at the default log level, it does? I don't have an explanation for this, sorry. ?Have you looked into the 1.5 second queries, what is sending them and

1.5 seconds is pretty long, I would look into what those queries are. I would also look into repeated queries, sometimes these things are clients stuck in a loop where they don't complete because they expect some termination condition. Andrew Bartlett On Tue, 2024-04-02 at 09:25 -0300, Elias Pereira via samba wrote: > The saga continues... > I've spent a whole day with log level 5

The saga continues... I've spent a whole day with log level 5 and 7 and no error. All I have to do is return the log to the default and the error reappears. I monitored the "LDAP Query: Duration", but I didn't notice any crashes in the queries. I don't know if it's a long time, but some queries took 1.5s. Is there anything else I can do? On Mon, Mar 25, 2024 at

Hello everyone, I have a problem when I execute queries using R 2.3.1 and MySql server 5.0. What I do: I load data in different csv files (every file represents a particular temporal step of a simulation) using Mysql query "load data" with RMySQL command DbSendQuery (but the same problem there is also using DbWritetable). Then I use a function where I have a lot of queries that interact

Hi everyone, I''m having trouble actually running mysql queries. I can connect to the database, I think, but when a query gets run the following shows up in my log: SQL (0.000000) Mysql::Error: Lost connection to MySQL server during query: SHOW TABLES Any suggestions? Thanks! Daniel Higginbotham

Hi All, Most of the work I am doing with R uses data which I am pulling from various SQL queries. To streamline the process even more, I was wondering if it was possible to embed SQL queries in R - that way avoiding the need to first get the data, then move to R to process it. I haven't found anything out there on this yet, so if you know of a good resource that includes this topic, I would