Linked Questions
35 questions linked to/from How do I add indexes to MySQL tables?
0
votes
3
answers
580
views
Indexing sql columns to speed up join query [duplicate]
On the first answer on this post: Update one MySQL table with values from another
it states that in order to speed up the query an index must be created. How do I do this?
I know it's fairly simple ...
- 10.2k
110
votes
10
answers
110k
views
How many rows in a database are TOO MANY?
I've a MySQL InnoDB table with 1,000,000 records. Is this too much? Or databases can handle this and more? I ask because I noticed that some queries (for example, getting the last row from a table) ...
- 30.2k
10
votes
6
answers
2k
views
MySQL statement takes more than minute to execute
I am working on a website in which the database is huge. 1 million records are in the table at the time. When I perform a query then it takes too much time to execute. One sample query is given below:
...
- 257
2
votes
3
answers
6k
views
mySQL slow to UPDATE on a simple WHERE query
I have an InnoDB database table with about 160,000 records and a simple UPDATE query like:
UPDATE table SET field='12345' WHERE order_number=102192817
is taking a long time (over half a second) to ...
- 484
4
votes
2
answers
7k
views
How to improve the performance of MYSQL query?
I am currently uploading datafeeds into my database.In my database were dumped because of more than 1crores records are there.I need to improve or increase my MYSQL query performance in my site.Here ...
- 4,630
4
votes
1
answer
3k
views
MySQL - Search the database by text string with special characters
I have a news system, and we need you to access the details of the news from a link that will take the title of the news, not the news ID database.
Note: Some published news have words and letters ...
- 1,398
1
vote
2
answers
3k
views
Cannot add foreign key constraint (GUID)
I developing a synchronization module in vb.net, so for avoid duplicate id on different record I'm using the GUID. Now what I'm trying to do is set the GUID as primary key (PK) on my table. This is ...
- 1,901
0
votes
5
answers
2k
views
How to create an index for a large DB table
I've done many regular database queries in the past, but now I have a database of about 1.5 million entries and I need to be able to do a quick search for live update.
My database is all US zip code ...
1
vote
1
answer
2k
views
Rails migration file to create table and add unique index on two fields seems being ignored during migration
I'm totally stuck here! I want to add a unique index so that no two records in an association table can have the same combination of user_id and course_id.
I have created the following migration file ...
- 1,368
1
vote
2
answers
437
views
Possible way to find Username from 1000,000 Users entries
I have Db of 100,000 users in MYSQL. In that DB i am having column ID,username,Fname,Lname, etc..
When www.example.com/Jim or www.example.com/123 (Where JIM is username and 123 is ID in the users ...
- 159
0
votes
2
answers
2k
views
php server handling many requests [closed]
I have a php file that accesses a mysql database in the background given a few constraints and then returns some data.
The only issue is, if I get an influx of requests all at once then the last ...
- 778
2
votes
3
answers
695
views
Laravel/Mysql - Manipulate large data
Dears,
Actually, I would like to know the best solution to manipulate BIG DATA in LARAVEL/MYSQL.
In my system, am uploading daily excel file (5K rows) into my DB, in case I find the same row in my ...
0
votes
3
answers
611
views
SQL query response time vs table size
I have a database that is being accessed by a web browser. The query is pretty simple.
select * from table where ID="string"
the question I need to ask is that do I need to worry about the response ...
- 81
0
votes
1
answer
685
views
select statement runs very slow on mysql
This php select statement runs very slow even with limit = 10.
$conn = new mysqli($DBServer, $DBUser, $DBPass, $DBName);
if ($conn->connect_error) {
trigger_error('Database connection failed: ...
- 92
0
votes
1
answer
917
views
Table structure for social media content
I am developing a social media type site. I have begun initial design and ran into potential issues. The site revolves around components, sub-components, and sub-sub-components. It has a hierarchy ...
- 132