MySQL - Technical Simple Question

E

EFileTahi-A

Well-known member
Joined
Aug 8, 2004
Messages
539
Location
Portugal / Barreiro
Is 56000 Records too much on a table with 6 columns?

I mean, I have no ideia of how fast/slow is performing searchs in a table containing such number of records, yet, I actually dont know if 56000 are too many records for one single table at all....
 
Hmmm... I used google to browse anything related to this subject and I found out that a database can easly sustain millions of records... NICE :)

Now, I wonder how long does it take to select all these records through a SQL query...
 
Selecting ALL records dont take too long, its a partial search of an unindexed field that will take time ;)
 
kejpa said:
Selecting ALL records dont take too long, its a partial search of an unindexed field that will take time ;)
Click to expand...

Hmmm... So youre saying that if I select part of the records USING INDEXED field will not take that much time?

Tks for the reply by the way :D
 
Correct!
You should always keep an eye on your search queries and optimize the indexes. Theres a HUGE difference in response time (were still talking ms though ;)) with indexed and unindexed searches. Not to mention those banned "Like %searchtext%" queries.
There is a reason for the M in the LAMP light of internet...

/Kejpa
 
Back
Top