bulk

How can I do bulk search and replace with Perl?

Hi: I have the following script that takes in an input file, output file and replaces the string in the input file with some other string and writes out the output file. I want to change the script to traverse through a directory of files i.e. instead of prompting for input and output files, the script should take as argument a directo...

Recursive Bulk Edit in Linux

I am trying to change certain lines in multiple files (scattered in subfolders) without having to edit each file one by one. I was given by Chas. the following perl -pi.bak -e 's{[^/]Css/Template.css}{/Css/Template.css}' * and it worked like a charm but was wondering if this command or similar can be done recursively in one shot ...

What's the fastest way to INSERT loads of data from one table to another? (SQL Server 2005)

I'm basically trying to copy data from a table in one database in SQL Server 2005 to another table, with the same structure (but lots of indexes) in another database in the same SQL Server instance. My current approach is the obvious INSERT/SELECT: set identity_insert TargetDBName.dbo.TableName on insert into TargetDBName.dbo.TableNam...

Update the results of a SELECT statement

Oracle lets you update the results of a SELECT statement. UPDATE (<SELECT Statement>) SET <column_name> = <value> WHERE <column_name> <condition> <value>; I suppose that this could be used for updating columns in one table based on the value of a matching row in another table. How is this feature called, can it efficiently be used fo...

How to execute bulk delete with relationship in EJB3

I am trying to figure out how to execute a bulk delete on a @ManyToOne relationship without success. Scenario: Parent has many Downloads I want to execute a delete of all Downloads where the Parent date is > :some_date. I do not want to delete any of the Parent records, just the Download records. Download has a parent field that i...

Multi-threading & db record locks

Need help big time .... I need to create a .net application that will perform some bulk operations on , say around 2,000,000 records, in a table. There is a window of opportunity in which the application should run and try to process as many rows as it can. I am thinking that if I can have multiple threads of the app take 2000 records...

Personalised bulk email programmatically without timing out

I have a list of around 5,000 to 10,000 (individual user supplied) email addresses from people all over the world, each associated with their username and language codes. I also have a single message translated into the different languages of the users that I want to email. Now, I would like to send a single plain text email to each of t...

PHP Bulk Email - Dedicated IP Max?

Hi Is there any way i can send out about 3000+ emails from one php script request without overloading a dedicated IP... the max would be 500 per hour? If you dont get me.. here is detailed :) I can only send out 500 emails via the mail() function in PHP per hour via my dedicated IP, is there any way i could send out for example 3000 ro...

Sleep between calls of Mail() in PHP

How would i send an email, to say 3000 recipients - with a Max 500 emails / hours on my dedicated IP? So far my thought is to send each email every 9 seconds, this would come to about 450 emails an hour... but how could i do this? My plan for the sending of the emails would be the following... $emails = ARRAY OF EMAILS, MYSQL RESULT fo...

Portable JPA Batch / Bulk Insert

Hi, I just jumped on a feature written by someone else that seems slightly inefficient, but my knowledge of JPA isn't that good to find a portable solution that's not Hibernate specific. In a nutshell the Dao method called within a loop to insert each one of the new entities does a "entityManager.merge(object);". Isnt' there a way de...

Command to Bulk Compress All Files / Folders Under a Directory

I'm looking for a command that will compress every folder within a directory separately with the name of each archive reflecting the original folder name. I know that tar czvf example.tar.gz example/ will compress an entire folder. However, I have not found a command to bulk archive. Is there such a command? ...

How can I pay only once to provide the same expensive data source to multiple unit tests?

G'day! I have 4.6GB of test data in 220,000 files. A bulk test requires finding, matching, and unzipping pairs of the files. I want to run multiple unit tests across each pair. It'll take a dreadfully long time if I can't persuade the test framework to find, match, and unzip the test data only once regardless of the number of unit tests...

Sending bulk mail using PEAR::Mail in php?

I am new to PEAR::Mail, and I am looking for a tutorial that can teach me how to send bulk mails(10K+ emails). "Using mail() in php is not efficient, as its open and close the smtp sockets", this is what I read from internet sources (could not find link now, grrr). Thus, I am thinking of doing it manually and using mail library that ar...

Bulk entity delete in Google App Engine

I'm trying to delete some unwanted data from my datastore with Java and found some code using the DatastoreService that I modified to delete as many entries as possible in 10 seconds: DatastoreService datastore = DatastoreServiceFactory.getDatastoreService(); Query query = new Query("PostalCodes"); long starttime = (new Date()).getTime(...

array insertion (Bulk insertion) in oracle table with OCI.

Hi, Can anybody help me in a OCI program. I need to insert multiple row in a table (bulk insertion i.e. multiple rows at a time) with one column with clob data type. I am not getting any appropriate example for this. ...

SQL Server - bulk delete (truncate vs delete)

Hello folks, We have a table with a 150+million records. We need to clear/delete all rows. Delete operation would take forever due to it writing to the t-logs and we cannot change our recovery model for the whole DB. We have tested the truncate table option. What we realized that truncate deallocates pages from the table, and if I am...

How can I easily bulk rename files with Perl?

I have a lot of files I'm trying to rename, I tried to make a regular expression to match them, but even that I got stuck on the files are named like: File Name 01 File Name 100 File Name 02 File Name 03 etc, I would like to add a "0" (zero), behind any of file that are less than 100, like this: File Name 001 ...

Performing bulk processing in ASP.NET page

We need the ability to send out automatic emails when certain dates occur or when some business conditions are met. We are setting up this system to work with an existing ASP.NET website. I've had a chat with one of the other devs here and had a discussion of some of the issues. Things to note: All the information we need is already m...

Sybase JConnect : ENABLE_BULK_LOAD usage

Can anyone out there provide an example of bulk inserts via JConnect (w/ENABLE_BULK_LOAD) to Sybase ASE? I've scoured the internets and found nothing. I'm running on a short timeline so if someone can provide a short java code example it would be much appreciated. Thanks, Chris ...

Linq to Nhibernate Bulk Update Query Equivelent?

Hi, Not sure if I'm missing anything here. Basically, I am looking for Linq to Nhibernate to do the following SQL statement: update SomeTable set SomeInteger = (SomeInteger + 1) where SomeInteger > @NotSoMagicNumber Is there any way to do that? Thanks! ...