Stack Overflow
Stack Overflow

Questions tagged [bulk]

The meaning of bulk is the major portion or greater part of any size, mass, or volume.

946 questions
8
votes
3 answers

Django: Bulk operations

Business: I encountered a problem - when operating with large datasets with Django ORM, canonical way is manipulate with every single element. But of course this way is very inefficient. So I decided to use raw SQL. Substance: I have a basic code…
Gill Bates
  • 14,330
  • 23
  • 70
  • 138
8
votes
2 answers

Oracle: Bulk Collect performance

Can you help me to understand this phrase? Without the bulk bind, PL/SQL sends a SQL statement to the SQL engine for each record that is inserted, updated, or deleted leading to context switches that hurt performance.
Revious
  • 7,816
  • 31
  • 98
  • 147
7
votes
1 answer

bulk inserts with SQLite and CoreData

I have a CoreData model that uses SQLite as persistence store. I need to insert large numbers of rows after doing some processing to each record. Is there any way to send those commands to SQLite PRAGMA synchronous=OFF PRAGMA…
محمد الاشرف أنور
  • 302
  • 3
  • 13
7
votes
3 answers

How can I delete expired data from a huge table without having the log file grow out of control?

I have a huge table (3 billion rows), which unfortunately contains mostly expired data. I want to simply delete all of these expired rows, and keep the rest. I can execute a statement like this: delete from giganticTable where exp_date <…
polygenelubricants
  • 376,812
  • 128
  • 561
  • 623
7
votes
0 answers

SQLAlchemy bulk create if not exists

I am trying to optimize my code by reducing the calls to the Database. I have the following models: class PageCategory(Base): category_id = Column(Text, ForeignKey('category.category_id'), primary_key=True) page_id = Column(Text,…
PepperoniPizza
  • 8,842
  • 9
  • 58
  • 100
7
votes
1 answer

Add custom bulk actions to admin orders list in Woocommerce 3

In Woocommerce backend (admin), I have a function that allows the shop-manager to download all orders between two dates with a specific bunch of required data: function write_to_file($date_initial, $date_final) { global $attach_download_dir,…
Lcapitao
  • 193
  • 1
  • 5
  • 14
7
votes
2 answers

Instagram API get bulk objects by comma separated IDs

I have a simple application where I have a bulk Instagram object ids. I'm looking for an API, from where I can send the ids as a comma separated string or in a similar fashion and get a list of Instagram objects. I'm unable to find an endpoint in…
Visahan
  • 1,130
  • 2
  • 14
  • 35
7
votes
1 answer

How to remove multiple courses in bulk in Moodle

Is there a way to remove multiple courses at once? It seems I can only do this one by one. Perhaps there is a better way, but I haven't found anything yet.
freke70
  • 91
  • 1
  • 5
7
votes
3 answers

Out of memory exception in SQL Server 2012

I am trying to execute a large sql script which contains about 1000000 simple UPDATEqueries. The total size of this script file is about 100 MB. When I run this script I'm getting an Out Of Memory exception. When I split the file into chunks of 10…
David
  • 625
  • 6
  • 14
7
votes
2 answers

libusb bulk transfer

I am trying to implement user space usb driver using libusb1.0.9. I have lpc2148 blueboard(ARM7) with me..This board is loaded with opensource USB stack/firmware by Mr. Bertrik Sikken. Now my user space driver is trying read write with board. I am…
swappy
  • 73
  • 1
  • 1
  • 4
6
votes
3 answers

Update the results of a SELECT statement

Oracle lets you update the results of a SELECT statement. UPDATE (