An evaluation of whether a system works well enough to be fit for purpose. Normally performance refers to the speed with which a system completes an operation or set of operations over time.

learn more… | top users | synonyms

1
vote
0answers
161 views

Multi-Table Join to Single Destination

I am having a serious performance issue with join together four tables and placing the results (in a certain permutation) into one destination table. I am using MSSQL 2008 and good ole T-SQL. To ...
0
votes
0answers
14 views

How to increase sql server performance? denormalization (making cascade delete off) vs making duplicate data

I have a database with following related table ( sql server enterptise edtion 2014) each state have many citites which each city has may municpalArea and so on State => Cities = > ...
0
votes
0answers
20 views

Calculating a running balance to store with transactions

I need to put a read-only copy of balance and transaction data from a legacy system, which will only be used to view/print statements. Balance | id | member_id | product_id | balance | | 1 | ...
0
votes
0answers
27 views

Optimal way of loading, registering, indexing and querying a huge XMLDB

I've got 35 million highly structured XML documents, with a total size of 500 GB. An XSD is available for this data, and the end goal is to transform the data into an RDB. All fields can be considered ...
0
votes
0answers
20 views

MySQL DATE vs DATETIME read/write performace

Did anyone perform accurate read/write performance comparisons of MySQL's DATE vs DATETIME column types? Please do not bother writing "It should be faster" or "I think it's faster". I am looking for ...
0
votes
0answers
27 views

What is “good” single-block read latency?

Is there a reference anywhere that I can go and see what kind of single-block read latency I can expect from Oracle given a certain hardware configuration? I can run a query to show the current ...
0
votes
0answers
15 views

Optimal layout strategies for Time-Series using Columnar storage

In the context of time-series and specifically columnar storage systems. Question: What are the processes or heuristics that are used to determine how best the columns of contiguous values be grouped ...
0
votes
0answers
9 views

MySQL: What are the pros and cons of running with engine=Memory vs on a memory-mapped filesystem?

What is the difference (in terms of read and write perf, alter tables, backup and recoverability and consistency) of running a MySQL database on a memory-mapped filesystem vs with ENGINE=MEMORY
0
votes
0answers
15 views

Which benchmark assess string pattern matching in a database?

I have a postgresql DB in which I do a lot of string matching ala : UPDATE table1 SET colum1 = TRUE WHERE colum2 LIKE '%teststring%'; colum2 is a whole html file As I said I do A LOT of this and ...
0
votes
0answers
24 views

How do triggers work on partitioned tables?

I have partitioned a table on the basis of a column. This column can either have 0 or 1. So, only two partitions (p0, p1) have been created internally. On this table there are 3 triggers which execute ...
0
votes
0answers
15 views

Performance implications of mixing VARCHAR and CHAR fields in MySQL Table

I read the following answers in this forum: What is the performance impact of using CHAR vs VARCHAR on a fixed-size field? MySQL: Does the order of the fields in a table make a difference in ...
0
votes
0answers
32 views

Bulk update performance

I have a several process that aggregate some statistics on items (how much was shown, clicked ... around 30 factors). Once in a 5 minutes i flush the aggregate data to postgres (9.1). I have 250K ...
0
votes
0answers
38 views

How can I decrease FULLTEXT initialization time?

I'm trying to decrease execution time of the a query. Using SHOW PROFILE, FULLTEXT initialization takes about 0.3, which is too high. Other values are at normal level. How can I decrease FULLTEXT ...
0
votes
0answers
38 views

performance questions in database design

I need to describe a set of studies that are practiced to a patient, every patient have a "Clinical History", that are described in another table called "Clinical History Lines"(hclines) Every visit ...
0
votes
0answers
16 views

What is the optimal way to get a tabular view from an Entity-Attribute-Model table?

Following up on my previous question, I have created a table for storing measurements of different physical quantities. The schema looks like this: CREATE TABLE sensorreadings ( time TIMESTAMP, ...
0
votes
0answers
41 views

Database design for large incoming data

I've been tasked to design a database to handle a large volume of incoming traffic from sensor readings, possibly 1,000s an hour when it's at full strength. Each reading will be relatively short - ...
0
votes
0answers
58 views

A working view now starts timing out

I have 2 identical databases (one larger, one smaller) with identical views. Recently a view on the smaller DB started timing out. Google searches seems to point to deadlocking of some sorts. If I ...
0
votes
0answers
32 views

Mysql table with only two columns, nothing unique: Will an index increase search performance?

If my table only has two columns (username, groupname) and a million or so rows, will an index improve performance at all? Wouldn't it take just as long to search the index file as it would to search ...
0
votes
0answers
46 views

MySQL 5.5, Xubuntu 14.04 - INSERT and UPDATE bottleneck

DBAs: I have been developing and maintaining plugins for Moodle for the last ~2 years, and have recently decided to try using my local desktop again, rather than my institutions ESX VMs, as a ...
0
votes
0answers
17 views

Sysadmin tools for SQLAnywhere

I'm seeing a performance issue in a 3rd party application based on SQLAnywhere 7. The DB engine seems to be dramatically underperforming on the hardware provided. It seems to have a upper limit on the ...
0
votes
0answers
11 views

Page cache installation in magento admin panel

Hi just added pagecache from varnish in Magento through the magento connect. It went in ok, just wanted to know, the correct configuration. In magento admin panel for the correct set up in the page ...
0
votes
0answers
56 views

Performance: Interleaving several statement handles in MySQL

Does interleaving several statement handles slow the system down? Example (Perl): $sth1->execute(...); $sth2->execute(...); $sth1->execute(...); $sth2->execute(...); (interleaved) vs ...
0
votes
0answers
25 views

Excesive use of RAM on MysqlServer

The RAM of a server where I have installed mysql is always 100% and looking at the processes that are running, MySQL is the most consumer on CPU and memory and I can see the cause of great use RAM.   ...
0
votes
0answers
68 views

Performance issue in Postgresql9.3

I have very good configuration server dedicated only for PostgresSql. Server is 16 Core 122 GB RAM on Linux machine. select version(); **PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by gcc ...
0
votes
0answers
16 views

View in View slower to execute?

Sometimes it's easier and clearer arranged to create a View from another View. Can this cause some speed losses in relation to selecting everything just in one Big and long View-Command?
0
votes
0answers
22 views

Performance tuning in Sybase

Does Sybase have a tool like AWR in Oracle which can be used to identify high load SQL, tell the important waits that are happening, help in understanding the workload? What are the main tools to be ...
0
votes
0answers
22 views

Approaching multiple values in same column

I'm developing an Android-application that scrapes the schedule for my university and presents it nicely since the current system is a nightmare. I'm processing a lot of data and it gets down to ...
0
votes
0answers
34 views

Oracle 9i Low performance on Windows Server Enterprise 2003

I'm facing some problems with performance with my Oracle database running on a virtual machine with Microsoft Windows Server Enterprise 2003 with 8GB RAM. It works pretty well after the database is ...
0
votes
0answers
71 views

MySQL: after query optimization the CPU is still over 100%

my first time here! First of all I want to say that I'm not a DBA and I have a very little experience with MySQL but I like to study and understand what I'm doing. I have a virtual machine (2gb RAM, ...
0
votes
0answers
29 views

Oracle after insert trigger vs update performance in plsql block

I want to know whether an after insert trigger is better than an insertion statement followed by update statement in plsql block.
0
votes
0answers
55 views

SLEEP_TASK and PAGELATCH_XX peaking after upgrade to R2 SP1

I wanted to just add a comment to this question: SLEEP_TASK Wait Type in SQL Server - What does it indicate? But I'm having not only SLEEP_TASK wait but also PAGELATCH_SH and PAGELATCH_EX wait types. ...
0
votes
0answers
18 views

How can I determine the performance (rows/second) for a certain query on one of my tables?

I want to find the performance (rows/second) for an UPDATE query on one of my tables so I can adjust my WHERE clause to select an appropriate number of records. The table has around 10 million rows. ...
0
votes
0answers
35 views

more queries vs storing results in database

Environment: Embedded (smartphones) Data Structures: Object Table A: id, field1, field2... Object Table B: id, field1, field2... Object Table C: id, field1, ... , Object A, Object B ... many ...
0
votes
0answers
58 views

Adding additional condition significantly degrades performance

Have the following query: SELECT * FROM table_A INNER JOIN table_B ON /* conditions */ INNER JOIN table_C ON /* conditions */ INNER JOIN table_D ON /* conditions */ WHERE table_B.state = 'active' ...
0
votes
0answers
178 views

Are mongodb bulk inserts really increase server perfomance (and faster)?

Bulk inserts always are faster in client side because of saving round-trips, but at the server-side is there any sensible performance improve? It seems the code for bulk inserts, just loops over ...
0
votes
0answers
27 views

Performance : MySQL replication or only one big server?

I'm searching about the best choice. We have to host a website with 10.000 - 20.000 visitors per day actually, growing. At the beginning, which would be the best : Having 2 MySQL servers (12 GB ...
0
votes
0answers
50 views

Big Mysql table optimization

I have a table that I use to cache google translate API answers. Table structure is orig_string and group are indexes Now it has more that 1million rows with 35000 distinct values in group field. ...
0
votes
0answers
55 views

Efficient way to fetch/update X records in a loop

What I need is a simple process that handles requests. I have setup a simple table as follows: CREATE TABLE Requests ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, request_param VARCHAR(250) ...
0
votes
0answers
43 views

Sql Server Standard VS Enterprise

I have been bench-marking SQL Server Enterprise and Standard, Enterprise is using Partitioning by month on the table. The table only has 3 fields, Date-time (DateTimeOffeset(3)), Value (integer in the ...
0
votes
0answers
32 views

How can the performance of a query that has a condition on two fields of each row be improved?

I have an images table with approximately 5 million rows in it. For the purposes of this question lets say the table looks like this: CREATE TABLE `images` ( `id` int(11) NOT NULL AUTO_INCREMENT, ...
0
votes
0answers
139 views

index usages on table with recursive relationship

we are working on a project that uses jpa and oracle. In this project we have a table with a recursive relation: Create table alarm ( id varchar2(200), ... alarmcode varchar2(50), parent_id ...
0
votes
0answers
118 views

Performance measurement in PostgreSQL

When developing server-side stored procedures performance measurement is an important issue. EXPLAIN ANALYZE is very usefull, but when it comes to simple queries like SELECT name FROM clients WHERE ...
0
votes
0answers
72 views

Explain difference between insert as select and select

Can someone explain why there is plan difference? Same query, same time the explain plan taken. I understand what happen (different order of getting the data) and how to fix it(move to forall insert ...
0
votes
0answers
82 views

Mysql profiler different duration information_schema.profiling

Hi! I have a problem and no idea how to resolve it. I'm trying to use mysql profiler. I'm using the command: set profiling=1; to turn it on. Later, i execute my query which is correlated ...
0
votes
0answers
44 views

query comes in slow query when log_queries_not_using_indexes is enabled

This query comes in slow query log when log_queries_not_using_indexes is enabled. SELECT a.id, d.id AS city_id, d.city FROM booking a, sub_area_master b, area_master c, city_master d WHERE ...
0
votes
0answers
65 views

H2 database binary file full of @^@^@^@^

I am investigating H2 database performance and was curious to why the database file was several megabytes long when only storing hundreds kilos of text, I therefore opened the database file with vim ...
0
votes
0answers
53 views

Slow exporting SAP Data Services to MySQL (Oracle is faster)

We've a MySQL 5.1 server and we are trying to import data from SAP Data Services from another server. It works but it takes 3h! We tried to setup an Oracle XE server to test the same operation and it ...
0
votes
0answers
51 views

How to optimize subselect join on large tables

There exists a need to migrate from one definition of a column to the next, so a backfill must occur. In order to get a grasp for the task at hand, I needed some background on the data being updated. ...
0
votes
0answers
135 views

Mysql View Performance on Aggregate Functions

I've a table that contains weekly statistical infos. ex. Society - Week - Year - Data AAA Inc - 1 - 2014 - 10250 AAA Inc - 2 - 2014 - 5235 BBB Inc - 2 - 2014 - 3210 ... Over this table i need to ...
0
votes
0answers
72 views

Order before Group

I have this query: SELECT HOTEL.hotelname AS NAME, HOTEL.`boardbasis` AS board, HOTEL.`engine`, HOTEL.`itemcode`, Group_concat(Round(((hotel.cheapestprice / 2) + ...