similar to: Slow bulk insert query

Hi, This code loops through my results and saves them : @results.each{|r| r.save} There are potentially thousands of results. This takes ages to complete. Is there a quicker way to do this? Any help is greately appreciated Thanks Chris -- Posted via http://www.ruby-forum.com/.

Hi all, I am trying to create a "index.csv" with caliculating different types of caliculations . In that i have to caliculate on 10,000 studies and have to insert many no of rows more than 500,000 for that right now I am inserting every row after caliculating and doing data.frame but its taking much time to create that index.csv is there any thing like bulk insert in to file

Hello, I'm trying to take a Samba-integrated file storage appliance with ZFS as the underlying file system (Nas4Free, in its latest incarnation, to be specific) into use and have gotten it Active Directory integrated just fine, and created shares on it. I can set the owner of the share to the domain Administrator, and I can alter ownership information from a Windows box just fine. ACL's

Hello, i have successfully installed samba 4 on three vmware VM's and everything works fine (join pc to domain, user login, dns updates, ntp), but i am facing some performance problems during users bulk loading. my environment: 1st DC: RedHat Linux v6.4,samba 4.1rc4,dns 9.9.3P2,ntp 2nd DC:RedHat Linux v6.4,samba 4.1rc4,dns 9.9.3P2,ntp 3rd DC:RedHat Linux v6.4,samba 4.1rc4,ntp to bulk load

I have a table (contact) with several fields and it's PK is an auto increment field. I'm bulk loading data to this table from files which if successful will be about 3.5million rows (approx 16000 rows per file). However, I have a linking table (an_contact) to resolve a m:m relationship between the an and contact tables. How can I retrieve the PK's for the data bulk loaded into

Hi! I am finding Dovecot very slow to delete large numbers of messages. IS this a known problem? Leslie

Can anyone explain to me the sql query done in the last step : http://pastie.org/402200 -- Arpit Jain --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group,

Is there some limit for the maximum length of the line in dovecot-sql.conf? In particular, I would be writing a long MySQL password query. And further, can a long line be somehow split to several pieces? I tried the common unix-style way of putting backslash as the last character of the first line, but it results in an error immediatedly while restarting Dovecot (while parsing the conf, ie. not a

I need to insert ~100k rows into the database, but using "Table.new(...).save" is painfully slow (I notice in the logs that it''s wrapping each insert in a transaction -- that can''t be fast). Any suggestions on how I can improve the speed of bulk inserts like this? Thanks ... -- Steve

Hi there! I am PHP developer and trying to learn ROR. Currently I am building my first Rails website (OS X Snow Leopard, TextMate) and decided to switch from sqlite to mysql. After many-many hours of searching the internet I managed to install mysql gem. Now I get this error when I try to run rake migrations: rake aborted! Mysql::Error: query: not connected: CREATE TABLE `schema_migrations`

Dear Thierry, thank you for the quick reply. I have only one question about the approach you proposed. As you suggested, imagine that the model we end up after the model selection procedure is: mod2.1 <- lmer(dT_purs ~ T + Z + (1 +T+Z| subject), data =x, REML= FALSE) According to the common procedures specified in many manuals and recent papers, if I want to compute the p_values relative to

This drives me insane on a regular basis. How does one mock system(''blah'') or `blah` ? Adding expectations on Kernel doesn''t do it. Adding expectations on Object just makes me sad: Object.any_instance.expects(:system).with(''ls'') # => #<Mock:0x12b584e>.system(''ls'') - expected calls: 0, actual calls: 1 And this really

For those of you following the earlier saga of the performance of limited eager loading, I''ve decided to give up on pursuing my original patch. I received some support on the simplification argument (see my blog if you don''t know what I''m talking about), but it doesn''t seem like it''s worth breaking existing behavior. So I''m moving onto

Guys, How can we provide bulk sms and bulk email functionality in a merb application. Can you help me in this issue...

Hi, There are 3 models: A has_many :Cs B has_many :Cs C belongs_to A and B I got a single object of A and an array of B objects. How can I get all Cs that have a_id equal to object A.id *and* b_id that belongs to an object in Bs array? Regards --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails:

I''m not using ferret because the search I need is not that complicated. I created a basic active record search. I''m using some code from the pragmaticprogrammer book. This is the issue: I can get the single keyword to work fine when entered into the search box, but when you put to keywords separated by a space the search returns no results. It makes sense since the function

I''m really new to Ruby on Rails, and I''m trying to read an XML file with REXML. No matter what I try, I am only getting the last result returned from my query. I should be getting 365 results. Here is the code: include REXML require ''rexml/document'' require ''rexml/xpath'' class MakeFootprintController < ApplicationController def index

Dear all, We have a problem with reading some characters correctly from an UTF-16 encoded database. The code below givens the correct characters on Ubuntu with the_driver = {ODBC Driver 13 for SQL Server}. On Windows (with the_driver = {SQL Server}), special characters like '?' and '?' are returned as '?'. I've added the sessionInfo() output from both machines. Any

Hi all, In one of my create action in the controller, I am catching a error and trying to show errors on the same page. It was all good when I called render action => ''new''. However, I also wanted to append a query string for consistence purposes. How do I do that with render? For now, I can only call redirect_to and put the error in the flash variable which

Hi, im trying to create an application for multiple customers, where data shouldnt be accessible to others. So ive added a customer_id to every db-table where it matters. Question: How can i add a Statement to find and other sql-commands so i just pull out the ones belong to the customer, without having to add :customer => customer to every find query? Whats the easiest way? a before_filter