Stack Overflow
Stack Overflow

Questions tagged [partitioning]

Partitioning is a performance strategy whereby you divide possibly very large groups of data into some number of smaller groups of data.

Partitioning is a performance strategy whereby you divide possibly very large groups of data into some number of smaller groups of data.

The expectation is that with algorithms of order exponentially greater than N the total time it takes to process the smaller groups and combine the results is still less than the time it would take to process the one larger set of data.

Partitioning is similar to range partitioning in many ways. As in partitioning by RANGE, each partition must be explicitly defined.

3138 questions
1
vote
3 answers

how do i do two partitions but in between draw a vertical line in css

i'm trying to make two partitions one part contain image and another part contain text. i have provided image like how i want to make it but sorry i can't provide image over here because of less than 10 reputation i have it need at least 10…
Archan Ghatpande
  • 41
  • 6
1
vote
0 answers

partition size in centos 7 for mysql

I want to have a server as a database server with mysql. I want implement it on centos 7, but I have a problem about partition configuration in centos. I want install only mysql on this server and I want know, how much should be assigned space to…
Sadegh
  • 21
  • 4
1
vote
2 answers

Select distinct. Most suitable technique to reduce wait time

I have lots of rows in my table in Postgres DB. I make insertions in this table every 20 minutes, clear old entries every day and have only 2 selection options from it. So I want to optimise time, that I wait for my selections. First selection is…
Snobby
  • 1,067
  • 3
  • 18
  • 38
1
vote
1 answer

Oracle partition

I have one table which has 100 partitions, And I have procedure which reads the data partition wise. Suppose P0 is 1 partition if I execute procedure exec xyz('P0'); it takes 3 minute to execute for 500k rows. But when I create 100 sessions and…
Sparsh
  • 39
  • 6
1
vote
1 answer

Quicksort not working with large array

I am trying to implement a quicksort algorithm with Hoare partioning which can work with a large set of array. It works with small size arrays however when creating a large array the application stops working. Can anyone help? The implementation…
user2439427
  • 131
  • 1
  • 9
1
vote
2 answers

Partitioning Views in sql

How do I partition an Indexed View in MS-SQL ? I have a index view created which stores range of values. The view definition is as follows CREATE VIEW dbo.target_individual_product WITH SCHEMABINDIN AS SELECT day_dim.date_time AS Date, …
Deepak
  • 6,684
  • 18
  • 69
  • 121
1
vote
3 answers

How to create partition on remote tablespace in Oracle?

I'm a noob in Oracle, is it possible to partition a table to remote server using db link? is it possible at all? I'm trying something like this: CREATE TABLE Test ( TestID integer not null, Name varchar2(20) not…
Burjua
  • 12,506
  • 27
  • 80
  • 111
1
vote
1 answer

How to efficiently delete expired rows from a large MySQL table

I have an extremely large table from which I would like to delete old rows. Example of table: | customer_id | first_purchase_date | last_purchase_date | || | | ** I am using this example table…
AYR
  • 1,139
  • 3
  • 14
  • 24
1
vote
1 answer

how to balance the load while using hash partition-er?

In apache spark -> By using the Hash partition-er , I believe the keys with same hash value will go on to same node? what if most of the keys goes on to same partition-er and how to balance the data on multiple worker node in such scenarios .…
nikhil08
  • 23
  • 3
1
vote
2 answers

How to modify Lomuto partition scheme?

Lomuto partition is a simple partition algorithm used in quicksort. The Lomuto algorithm partitions subarray A[left] ... A[right] and assumes A[left] to be a pivot. How to modify this algorithm to partition A[left] ... A[right] using a given pivot P…
Michael
  • 41,026
  • 70
  • 193
  • 341
1
vote
1 answer

How Partitions are split into Kafka Broker?

I know that partitions are split across Kafka Broker. But the split is based on what ?. For instance, if I have 3 brokers and 6 partitions, how to ensure that each broker will have 2 partitions ? How this split is currently made in Kafka ?
arruran kamalakumar
  • 33
  • 1
  • 4
1
vote
0 answers

Why does querying an external hive table require write access to the hdfs directory?

I've hit an interesting permissions problem when setting up an external table to view some Avro files in Hive. The Avro files are in this directory : drwxr-xr-x - myserver hdfs 0 2017-01-03 16:29 /server/data/avrofiles/ The server can…
s d
  • 2,666
  • 4
  • 26
  • 42
1
vote
1 answer

Rebuilding index takes 5-6 hrs. Can it be reduced?

We are using Informatica for ETL and the database is Oracle 11g. We have a fact table (2 billion records) which is loaded daily. There are around 44 indexes for this fact table and the fact table is partitioned. We are following the below process…
XING
  • 9,608
  • 4
  • 22
  • 38
1
vote
2 answers

How can I Access Different Java Partitions in my IDocument

I am currently developing a plugin in which I need a function to only execute when my cursor is within a javadoc comment partition. I have tried to execute IDocument.computePartitioning() as well as IDocument.getContentType(). So far the only…
Bejal
  • 91
  • 7
1
vote
1 answer

Partition table get locked for concurrent DML operations in Oracle

I have created one partition table in Oracle 11g and tried to insert records using Multithreading from Java batch job. Let's say, if I have 10 threads, & each wants to insert/update 1 million records concurrently or bulk insert some time without…
Syed Samiuddin
  • 11
  • 3
1 2 3
…
99 100