database-optimization

相关标签：javascript jquery android 多少钱 iPhone

mysql optimization script file

I\'m looking at having someone do some optimization on a database.If I gave them a similar version of the db with dif开发者_如何学Pythonferent data, could they create a script file to run all the opti[详细]

2023-04-11 06:23 分类：问答
Is there a performance benefit to creating a multiple index on a primary key + foreign key?

If I have a table that has a primary key and a foreign key, and searches are frequently done with queries that include both (...WHERE primary=n AND foreign=x), is开发者_如何学Python there any performa[详细]

2023-04-07 07:51 分类：问答
Problem with PHP/MySQL Insert

How to insert data into two or more tables? Currently I am using this trick. (Let just assume that the syntax is correct)[详细]

2023-04-06 08:23 分类：问答
Inventory Database Design

I\'m fairly new to using MySQL and I\'m trying to understand what the most efficient way to store a player\'s inventory items in my database is.[详细]

2023-04-03 23:30 分类：问答
Best way to count rows from mysql database

After facing a slow loading time issue with a mysql query, I\'m now looking the best way to count rows numbers. I have stupidly used mysql_num_rows() function to do this and now realized its a worst w[详细]

2023-03-26 00:04 分类：问答
ORDER BY NULL slower than ORDER BY column

according to MySQL documentation, adding ORDER BY NULL after GROUP BY should \"avoid the overhead of sorting the result\". If so, why is following query aprox 5 times slower[详细]

2023-03-22 18:36 分类：问答
Solution for speeding up a slow SELECT DISTINCT query in Postgres

The query is basically: SELECT DISTINCT \"my_table\".\"foo\" from \"my_table\" WHERE... Pretending that I\'m 100% certain the DISTINCT portion of the query is the reason it runs slowly, I\'ve omitt[详细]

2023-03-18 16:23 分类：问答
Questions regarding a optimizing a slow query (SQL included)

SELECT DISTINCT \"myapp_profile\".\"us开发者_如何学Goer_id\", \"myapp_profile\".\"name\", \"myapp_profile\".\"age\", \"auth_user\".\"id\", \"auth_user\".\"username\",[详细]

2023-03-16 14:42 分类：问答
How to manage Huge operations on MySql

I have a MySql DataBase. I have a lot of records (about 4,000,000,000 rows) and I want to process them in order to reduce them(reduce to about 1,000,000,000 Rows).[详细]

2023-03-13 00:25 分类：问答
Worth adding indexes on a column just to make them a foreign key?

I have 开发者_运维技巧an invitations table in my database, which has got a from and to columns, which are both foreign keys for the userId column in my users table.[详细]

2023-03-07 06:17 分类：问答