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.
2
votes
0answers
150 views
Which is faster: Intent.putExtra or SQLite query?
I want to know that which way is faster in performance between Intent.PutExtra or SQLite query.
Should I attach all attributes of an object with the intent i.e, ID, First Name, Last Name, Location, ...
android
2
votes
0answers
470 views
MySQL with Entity Framework is slow because of derived tables. How can I fix it?
I am using MySQL Connector/Net 6.5.4 with LINQ to entities, and I frequently get terrible query performance because the entity framework generates queries that use derived tables.
Here is a ...
2
votes
0answers
243 views
How to build hierarchical ACL/ACE with Symfony2?
Is there any way to build hierarchical ACL with Symfony2?
I need to build an admin area with a simple Category/Article one-to-many relation. Is there any way to build ACLs so that every ACE on the ...
2
votes
0answers
1k views
SQL Server Indexes INSERT/UPDATE Performance
I know that indexes hurt insert/update performance, but I'm trying to troubleshoot and determine the right balance between query performance and insert/update performance.
We've created a number of ...
2
votes
0answers
253 views
Can I stop Hibernate from generating union queries when querying fields with inheritance?
I have a JPA hierarchy where one object contains a Set of an abstract type, implemented by a varying number of sub-classes. The problem is that when Hibernate tries to load these classes it generates ...
1
vote
0answers
37 views
Why is SQL cast expensive?
I was wondering what is the background explanation for this? I see from testing examples that casting is very time consuming but I don't realize why since I don't know mechanics in behind, and I would ...
1
vote
0answers
19 views
Comparison of sets in MySQL
I have a challenge with the following database structure:
HEADER table called 'DOC' containing document details among which the document ID
DETAIL tabel called 'DOC_SET' containing data related to ...
1
vote
0answers
52 views
How can I improve this ugly Postgresql query generated by my possibly poor Django code?
I'm doing this in a Django view:
def by_gear(gear):
types = {
'imaging_telescopes': Telescope,
'guiding_telescopes': Telescope,
'mounts': Mount,
'imaging_cameras': ...
1
vote
0answers
67 views
How shall I store and check for custom access tokens using MySQL and PHP?
Tools: PHP and MySQL
Goal: select a given access token quickly from MySQL.
Access Token: a long string that is generated by me to be used as part of a session for that user. (generation method is ...
1
vote
0answers
58 views
Basic Insert / Update Performance Issue
Running MySQL Database and all tables are InnoDB
Every evening we have a list of the top offending slow queries emailed to us via a batch script.
In this list are two queries an insert and an ...
1
vote
0answers
147 views
MongoDB complex query for matching elements in array and performance
Say I have following data structure:
{
"_id" : LUUID("d14c526e-34ba-4c41-9bb0-3bc32d9de106"),
"Address" : {
"Street" : "Winner street",
"HouseNo" : "776",
"PostalCode" : 9619,
"City" ...
1
vote
0answers
53 views
MySQL: Index on Order By with range Where clause
Before I rewrite my query and code etc. etc., just want to verify that...
Is it true that there is no way to create an index, or rewrite the query below, in such a way that the index is used to ...
1
vote
0answers
125 views
Prepared Statements Count in Grails
On analyzing hibernate statistics for a Grails application there is an issue I can't understand. The value for PrepareStatementCount is increasing on each request. It doesn't matter if the request is ...
1
vote
0answers
42 views
Evaluating slow website
I'm trying to trouble shoot a website that my company hosts that seems to run very poorly during peak times. The site was developed by a developer (who has left the company) and was built on ...
1
vote
0answers
153 views
Implication of ActiveRecord::Base.transaction on multiple tables
I'm curious about how Rails with a MySQL database handles table/row locking on transactions that involve multiple tables.
I have a situation where I need to update many records at once, but I also ...
Related Tags
mysql × 58performance × 40
sql × 32
sql-server × 29
database × 23
oracle × 12
sql-server-2008 × 12
query-performance × 9
indexing × 8
entity-framework × 7
java × 7
database-design × 6
php × 6
stored-procedures × 6
hibernate × 5
mongodb × 5tsql × 5
c# × 5
oracle11g × 4
database-tuning × 4
oracle10g × 3
join × 3
sql-server-2008-r2 × 3
scalability × 3
sql-server-2005 × 3
Hot Network Questions
- Vending machine implementation
- Are most matrices invertible?
- Structures that turn out to exhibit a symmetry even though their definition doesn't
- Make a scalable Christmas Tree
- How to put on every page ornament symbol
- convert date format in log
- As a new faculty member, how do I avoid the Peter Principle?
- What does the linux "mkdir bin lib lib/NAME test" command translate into in Windows?
- Beamer: Overfull hbox in headline
- What should I consider before wearing Google Glass to a job interview when I do development for them?
- How is an XOR with more than 2 inputs supposed to work?
- Can a particle have momentum without energy?
- What is missing in this Mathematica Journal Article?
- Is it bad practice to use your real name online?
- Perform instruction in loop every time except the last time?
- When should I fudge dice rolls?
- Why didn't Sauron kill Gandalf
- Prove that of any 52 integers, two can always be found such that the difference of their squares is divisible by 100.
- Meromorphic function at conjugate
- Question about RC charge-discharge curve
- Why does the Sudan have a THE in the name?
- How can an extremely mathematically talented young person be helped to fulfill his/her potential?
- Why is argc not a constant
- Can I construct a Turing machine that accepts only its own encoding?
