Tagged Questions
0
votes
2answers
23 views
Partitioning MySQL for “expired” transactions to improve performance
I am dealing with an existing application that uses the database as a sort of transaction log in several cases, for example orders or payments. These tables are large (20 - 60 million rows) and poorly ...
0
votes
2answers
84 views
Storing data in PostgreSQL: One table or two?
I've just started using PostgreSQL 9.2 and my data consists of product prices at various points in time, usually a different price every month.
Question: Because every product can have different ...
0
votes
2answers
45 views
Accessing Database without using SQL
This might be some ambiguous but I have not much info about this so I need some start point;
As a general idea; in conventional RDBMS', there are a DB engine and storage of data. We use the language ...
1
vote
3answers
214 views
Which RDBMS has the most advanced “table-valued” functions?
Every Database Management System focuses on specific features and applications. I am using mysql, probably as it is popular and satisfies common needs. However, I came across a problem, which needs ...
1
vote
3answers
344 views
Detecting SQL Server Utilization with a query
My current project will send queries to an sql server constantly and It may use 100% of the memory or CPU.
How can I check if the server is nearing full utilization in a stored procedure so that I ...
2
votes
1answer
131 views
Restriction on self referencing on insert in MYSQL?
How to restrict insert on adding self referencing rows in a recursive relation table (a table contains foreign key points itself).
mysql> SELECT * FROM Employee;
...
3
votes
1answer
210 views
How to Update same table on deletion in MYSQL?
In my Database I have a table: Employee with recursive association, an employee can be boss of other employee.
Following is query I used to create table:
CREATE TABLE IF NOT EXISTS `Employee` ...
10
votes
3answers
427 views
Use MySQL to regularly do multi-way joins on 100+ GB tables?
Background:
I’ve created a web application that I would like to be able to scale reasonably well. I know I'm not Google or Twitter, but my app uses a fairly large amount of data for each user and thus ...
0
votes
0answers
87 views
recommend some good books on DATABASE MANAGEMENT SYSTEMS [closed]
Can anyone please recommend some good books on DATABASE MANAGEMENT SYSTEMS.
0
votes
1answer
290 views
which DBMS should i go for? [closed]
I am interested in learning a DBMS. As a beginner which DBMS should i go for ?
I know few DBMS by name like Oracle,Sql Server,My Sql . How are these DBMS different from each other ?
As a beginner ...
3
votes
3answers
459 views
MySQL very slow query when changing one WHERE field despite no index/key
This is quite a confusing issue for me. I have a database full of baseball statistics. Running this query:
SELECT * FROM hits
JOIN stadiums ON stadiums.gameName = hits.gameName
JOIN players ON ...
4
votes
0answers
138 views
Which SQL datatypes exist since when and in which RDBMS? [closed]
I found a general comparision of different SQL implementations that only covers some data types (BOOLEAN and TIMESTAMP) and a comparision of datat type support in different RDBMS from 2009 that does ...
