Questions about database performance and tuning, ranging from files organization and configuration to benchmarking and system optimization, passing through management systems and the fastest ways to operate a database.
0
votes
2answers
24 views
Store database connection in python?
I have a script A (python script) which opens the database and executes some queries and then closes the database connection.
I am not sure how long will script A run it all depends on the load.
I ...
0
votes
1answer
12 views
MySql database slow response with multiple large tables
I am new using Mysql and I am having problems when trying to read large tables of the data base. I have created the next data base:
CREATE DATABASE `chamber_master_db` /*!40100 DEFAULT CHARACTER SET ...
0
votes
0answers
10 views
TempInsertStateItemShort procedure on ASPState is taking more than 1 second to execute
I'm working on a .NET website who runs in load balance within more than one server and because of that I need to have my session on SQL Server.
In the last 2 weeks I've notice that the procedure ...
0
votes
0answers
10 views
What replication type we need to use for mssql 2012?
I am working for a e-commerce company which wants to separate its admin operations and make the front-end website completely independent.
This could be easy however, Client looking for options to ...
0
votes
1answer
13 views
A BLOB which isn't present in a SQLite SELECT statement can affect performance?
We have a table in a SQLite3 db something like this:
Create Table Images (ID PRIMARY KEY, Height INTEGER, Width INTEGER, FileName TEXT, Thumb BLOB)
The Thumbs are rather small (@ 20kb) and the ...
1
vote
1answer
21 views
Database design for the Lectures Scheduling for a Single Course
I want to store the Lectures Timing information in the 3rd Normalized Database.
The ER Diagram of the Lecture Info is as follows:
Since the Lecture_Day is multiple value attribute so i have ...
-1
votes
0answers
29 views
Improve performance of remote database query via API [on hold]
Basically, there are three web application which hosted in different server.
In my web application, I need to generate kind of report which need to trigger query from these three databases which they ...
0
votes
1answer
16 views
Performance issues of mysql query as compared to oracle query
I have created a complex view which gives me output within a second on Oracle 10g DBMS.. but the same view takes 2,3 minutes on MYSQL DBMS.. I have created indexes on all the fields which are included ...
0
votes
2answers
43 views
How many ways huge data can be optimize in table sql server
i was asked in interview if there is a table with 300000000 data & 300 fields then when people search data in that table the performance will be slow. so what are the steps u like to follow to ...
0
votes
2answers
28 views
Configure MS SQL Server to log query and its execution time
I had a program using SQLconnector to connect to MS SQL 2012, I want know SQL query execution time. I am aware there is a SQL Server Profiler, but I can't configure it correctly to capture any query ...
2
votes
0answers
22 views
How to test the data specific stress testing?
In my application there are hierarchy of lead user & child users i.e one lead user has multiple child users.
Lead user can view all the records of all the child users (i.e. suppose one lead user ...
-1
votes
0answers
32 views
How can I get better performance with this SQL database and its queries?
It is a ASP.NET MVC 4 web application using entity framework model first.
I have a database with two tables one that have static data which is called Category and another one called News.
This web ...
0
votes
1answer
27 views
Implementing queues using SQLite database in Android
I want to implement queues in one of my app. I've been investigating few options like file based queues and database queues. File based doesn't look like a right choice when data grows really big. I'm ...
android
0
votes
0answers
35 views
Reading a lot of MongoDB data with Java
I'm learning MongoDB and I'd love to get some help from the community...
I have an association one-to-many, where a string A could be associated with a lot of strings B. I tried to implement this in ...
4
votes
1answer
47 views
Brain-Dead MySQL Select Optimization (Using Temporary, Using Filesort)
I'm currently working on a project involving Patents pulled the USPTO website, as part of this project I'm using the database created by people from the University of Illinois
(Paper: ...
