database-performance Questions
1
Solved
What makes access to OLAP Cubes/Datamarts and similar datastructures, faster than to relational databases?
EDIT
A bounty of 200 will be provided asap.
Tideland asked 11/5, 2012 at 12:42
2
Solved
After noticing that our database has become a major bottleneck on our live production systems, I decided to construct a simple benchmark to get to the bottom of the issue.
The benchmark: I time ho...
Fidget asked 5/5, 2012 at 1:44
2
I am not asking for opinions but more on documentations.
We have a lot of data files (XML, CSV, Plantext, etc...), and need to process them, data mine them.
The lead database person suggested usi...
Extemporary asked 18/4, 2012 at 10:45
1
Solved
I can't seem to figure out why SQL Server is taking a completely different execution plan when wrapping my code in an ITVF. When running the code inside of the ITVF on its own, the query runs in 5 ...
Quincuncial asked 4/4, 2012 at 19:17
1
Solved
I am working a java application using H2 Database in embedded mode.
My Application consumes 150mb of heap memory.
Problem:
Steps
When I load H2 database with 2 mb of data, database access is fast ...
Astrometry asked 21/3, 2012 at 5:6
2
Solved
I'm using the external storage for storing events in a database while they are waiting to be sent to the server.
I'm seeing really bad performance when inserting records.
I know the external memor...
Bridgeboard asked 15/6, 2011 at 0:44
3
I use Microsoft SQL Server 2008 (SP1, x64). I have two queries that do the same, or so I think, but they are have completely different query plans and performance.
Query 1:
SELECT c_pk
FROM table...
Kirstinkirstyn asked 13/3, 2012 at 11:45
3
Solved
i used to write sql statments like
select * from teacher where (TeacherID = @TeacherID) OR (@TeacherID = -1)
read more
and pass @TeacherID value = -1 to select all teachers
now i'm worry about...
Strath asked 26/2, 2012 at 19:29
2
Solved
Let's assume you've got a nosql database - redis, cassandra, mongodb. And you need to check the overall performance for this database - various platforms, operation systems, even programming langua...
Ink asked 27/1, 2012 at 6:46
2
Solved
Possible Duplicate:
In SQL, what's the difference between count(column) and count()?
Count() vs Count(1)
I have big tables which keep long texts for example email content or news...
Allain asked 13/1, 2012 at 15:17
1
Solved
Here is my query:
SELECT * FROM [GeoName]
WHERE ((-26.3665122100029-Lat)*(-26.3665122100029-Lat))+((27.5978928658078-Long)*(27.5978928658078-Long)) < 0.005
ORDER BY ((-26.3665122100029-Lat)*(-2...
Tillietillinger asked 8/1, 2012 at 12:23
1
Solved
Consider a mobile device manager system that contains information for every user such as a table that stores the apps that he has installed on the phone, auditing details, notification inform...
Elephantine asked 1/12, 2011 at 11:36
8
Solved
We have an InnoDB database that is about 70 GB and we expect it to grow to several hundred GB in the next 2 to 3 years. About 60 % of the data belong to a single table. Currently the database is wo...
Illegality asked 5/9, 2008 at 13:59
3
Solved
Here is the scenario I find myself in.
I have a reasonably big table that I need to query the latest records from. Here is the create for the essential columns for the query:
CREATE TABLE [dbo].[...
Suctorial asked 22/9, 2011 at 13:17
2
I am working on a project based on PHP, Mysql , Apache.
I have a module called notification which is just like Notification available in FACEBOOK, for this I have 3 ways
either
I insert every up...
Exequies asked 10/8, 2011 at 5:54
2
Solved
I checked this SO post:
What's the difference between primary key, unique key, and index in MySQL?
and found the statement:
Also note that columns defined as primary keys or unique keys are au...
Oryx asked 20/9, 2011 at 13:2
4
Solved
We've been experiencing SQL timeouts and have identified that bottleneck to be an audit table - all tables in our system contain insert, update and delete triggers which cause a new audit record.
...
Fairminded asked 31/8, 2011 at 23:56
7
Solved
I have some queries that are taking too long (300ms) now that the DB has grown to a few million records. Luckily for me the queries don't need to look at the majority of this data, that latest 100,...
Roadbed asked 28/7, 2011 at 14:32
1
Solved
I've been searching the web looking for best practices for configuring MongoOptions for the MongoDB Java driver and I haven't come up with much other than the API. This search started after I ran i...
Cullet asked 29/6, 2011 at 12:12
3
Solved
I've started developing a browser (database) game. My question is how many queries can a regular hosting handle (when I mean regular, I mean a shared hosting you cand find for about 7$/month).
As ...
Quinlan asked 30/12, 2010 at 22:22
3
Solved
I have a table t with a column c, which is an int and has a btree index on it.
Why does the following query not utilize this index?
explain select c from t group by c;
The result I get is:
Has...
Citron asked 4/2, 2011 at 22:43
1
Solved
Consider the two following Python code examples, which achieves the same but with significant and surprising performance difference.
import psycopg2, time
conn = psycopg2.connect("dbname=mydataba...
Stygian asked 23/1, 2011 at 20:0
1
Solved
I would like to know the performance difference in updating a table using the following method:
UPDATE films SET kind = 'Dramatic' WHERE CURRENT OF c_films;
or like this:
UPDATE films SET kind ...
Capacitance asked 21/1, 2011 at 21:56
6
Solved
I have a buddy who runs a web app for people listing cars for sale. There are a few thousand clients who use it, and each client has hundreds and sometimes thousands of rows in the database (some h...
Answerable asked 10/9, 2010 at 22:34
2
Solved
There's a healthy debate out there between surrogate and natural keys:
SO Post 1
SO Post 2
My opinion, which seems to be in line with the majority (it's a slim majority), is that you should use...
Logarithm asked 4/8, 2009 at 18:36
© 2022 - 2024 — McMap. All rights reserved.