All Questions
135
questions
0
votes
2
answers
42
views
How to use correct indexes with a double inner join query?
I have a query with 2 INNER JOIN statements, and only fetching a few column, but it is very slow even though I have indexes on all required columns.
My query
SELECT
dysfonctionnement,
montant,
...
- 2,200
0
votes
1
answer
61
views
Is there a better MySql query that's more efficient
I have a query I built up with a little help from web searching, however it is not efficient with the large dataset I have. I set the query running 10 days ago and it's not finished. I have no idea ...
- 23
1
vote
1
answer
207
views
Neo4j graph performance: should I cache slow queries in a separate database?
Setup/Intro
I have 10k+ nodes in my Neo4j graph in which I need to display a sub-graph (100-500 nodes) between 2 start/end nodes on the frontend app along with info about the critical path and the all ...
- 308
1
vote
2
answers
1k
views
Increase performance on large dataset with pivot table relationships (Using Laravel)
Looking for advice on whether I can improve my database statements or if I should start caching query results to increase performance.
The schema is set up as a Many-To-Many Polymorphic relationship. ...
- 582
1
vote
0
answers
1k
views
Lazy loading data a la Skeleton Screens. Is it possible?
I've been reading the article The Vietnam of Computer Science by Ted Neward. Although there's much I don't understand, or have not fully grasped, I was struck by a thought while reading this paragraph....
- 2,273
-1
votes
1
answer
789
views
Advice on adding index in db2
Good day,
In my java web application, I have a table, which having 107 columns, and this table also a parent table, and having many child tables. Currently this table is having more than 10 millions ...
- 1,893
0
votes
1
answer
220
views
Table design for user likes relationship
An example I have 4 tables:
Users
Photos
Videos
Audios
I want to create a response feature like Facebook like. Which better:
Create 1 table which has columns:
id (int)
user_id(int)
...
- 7,726
0
votes
1
answer
57
views
B-Tree vs T-Tree - For lower workloads which is better?
Our application is using database(in-memory) which was using T-Tree until very recently.
Now, we have migrated to B-Tree and we have observed that for higher workloads(with millions of records ...
- 1,108
1
vote
0
answers
33
views
Which of the four designs outlined in this question will yeild the best INSERT time?
Which of the following four database designs would give me better insert times?
Design 1
ActivityType
--------------
Id -- (int primary key identity(1, 1))
ShortName -- (For e.g. 'Biking', 'Jogging'...
- 33.5k
2
votes
2
answers
272
views
Is it better to use more measurements or just use tags for performance
I am using InfluxDb for logging measurements of many power plants. Currently I am using one measurement with power_plant as a tag and than fields for measurements. Is it better to have different ...
- 359
0
votes
1
answer
1k
views
Database for product catalogue with multiple stores, hierarchical categories
I'm seeking for assistance on the decision of the best database, be that relational one or not, as well as the best schema for the given task.
The idea is the following: there is an offline store ...
- 1
0
votes
1
answer
269
views
How to store total visits statistics for user history efficiently?
I'm maintaining a system where users create something called "books" that are accessed by other users.
I need a convenient (good performance) way to store events in database where users visit these ...
- 2,210
0
votes
0
answers
21
views
Options to access database without perfomance impact
Requirement: Access very large SQL database during business hours to pull data every couple of hours / every 4 hours for latest data. Then store it in local database. Another tool will access that ...
- 15
1
vote
1
answer
137
views
AQT(Advanced Query Tool) Unable to convert an index (employee_id) to primary key
Working with optimizing my database and I have a problem when trying to edit a table where the employee id is already assigned as a unique index but not a primary key which is what I want.
I get the ...
user8506273
0
votes
2
answers
127
views
The best sale database structure for a book store
I have two database structure:
#1: Each book is a row:
// sale
+----+---------+-------------+
| id | book_id | customer_id |
+----+---------+-------------+
| 1 | 5 | 123 |
| 2 | 5 ...
- 6,559