All Questions
Tagged with database-partitioning performance
17 questions
0
votes
1
answer
530
views
How to optimize Oracle create table function for a table having over 30 million rows and 250 columns
I need to create a table which has over 30 million rows and about 250 columns from another table which has same row number and about 230 columns. It is like ETL process. I use SPSS Modeler to run a ...
- 1
0
votes
1
answer
199
views
mysql partition on categorical fields and timestamp column which is varchar
Currently we have table:
CREATE TABLE `T_TRANS` (
`CASE_ID` varchar(20) DEFAULT NULL,
`C_ID` varchar(20) DEFAULT NULL,
`C_ST_IND` smallint(6) DEFAULT NULL,
`D_DTTM` int(11) DEFAULT NULL,
`...
- 4,335
0
votes
2
answers
547
views
Does it make sense to split big DB2 tables into multiple tables to improve the performance?
We are currently having an OLTP application storing information in a DB2 database.
The information regarding the declarations is stored in multiple DB2 tables and some of the tables are really huge (...
- 342
0
votes
1
answer
44
views
How to define Indices on huge table (>38.700.000 rows) using group by, where and order by clause
I'm trying to speed up my Queries on a huge MySQL-Table (more than ~38.700.000 rows) but I can't figure out what to do. I read dozens of related Articles and even messed around with the MySQL-...
5
votes
1
answer
4k
views
What is the "internal hash function" for UUIDs in DynamoDB?
Amazon's DynamoDB documentation appears to be deliberately cagey about how a partition is selected for a row. Here is the discussion about the Partition Key (emphasis mine):
Partition key – A simple ...
- 4,027
0
votes
0
answers
413
views
increase the cost of query after partition the DB
i have a query with high cost , and this cost appear after i partition my db . i don't know what make this problem . partition is on date.
the query is :
update EBSESSIONSERVICE set RESPONSETIME=:1 ...
- 117
1
vote
0
answers
1k
views
Low performance on inserts with partitioned table in Oracle 12c
I have a partitioned table in oracle 12c with about 50 millions records. When i make a insert query against the db the response time is about 300 milliseconds, which is really slow compared to an ...
- 21
0
votes
1
answer
90
views
Best way to design for one-to-many code values in Oracle
We receive several millions of records per day on temperature metrics. Most of the pertinent metadata for these records is maintained in a single partitioned table by date (month). We are going to ...
- 7
0
votes
1
answer
973
views
MySQL partitioned table works slower than equivalent unpartitioned table
Help!
I have a table in MySql (without partitioning) with ~4 500 000 rows:
CREATE TABLE stat_accounts_history (
id bigint(20) NOT NULL AUTO_INCREMENT,
accountId bigint(20) DEFAULT NULL,
month ...
0
votes
2
answers
534
views
In MySQL partitioning a table, how is the DIV used here as part of the HASH partition definition?
I was reading about partitioning and somewhere I read the following example:
HASH (id DIV 1000000)
This can be used to create a new partition for each million rows inserted (id is the primary key).
...
- 19.6k
2
votes
2
answers
226
views
MySQL Partitioning: SELECT by ID, but DELETE by date
Consider the following table:
CREATE TABLE `event` (
`uid` bigint(13) NOT NULL,
`time` bigint(14) NOT NULL,
`type` smallint(5) NOT NULL,
`msg` varchar(2048) DEFAULT NULL,
KEY `uid` (`uid`),
...
- 21
0
votes
2
answers
627
views
Performance in a 1 million row MySQL-table in a chess game scenario
Say I run a game website where the users play chess to each other. I have a MySQL-table that contain all the games with their individual chess moves:
Games table (psuedo syntax):
gameId INT
...
- 7,403
2
votes
1
answer
8k
views
MySQL performance with large number of records - partitioning?
I am trying to build a database that would contain a large number of records, each with a lot of columns(fields) - maybe around 200-300 fields total for all tables. Let's say that I would have in a ...
- 2,550
0
votes
0
answers
152
views
How to partition a mysql table after the table is already created
I am trying to partition my table so I can narrow down the record so accessing data won't take as long as it is taking now.
this table that I want to partition has 2 key fields
(1) 'tigger_on' which ...
- 40.4k
0
votes
1
answer
135
views
MySQL DB: performance and partitioning
I've migrate an access DB to a MySQL DB. In particular, in this DB I've a table with almost 5 million of rows. The most part of operations on this table are queries (filters to select a data subset).
...
- 3,588