EFileTahi-A Posted September 19, 2005 Posted September 19, 2005 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 don't know if 56000 are too many records for one single table at all.... Quote
EFileTahi-A Posted September 19, 2005 Author Posted September 19, 2005 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... Quote
kejpa Posted September 19, 2005 Posted September 19, 2005 Selecting ALL records don't take too long, it's a partial search of an unindexed field that will take time ;) Quote
EFileTahi-A Posted September 19, 2005 Author Posted September 19, 2005 Selecting ALL records don't take too long' date=' it's a partial search of an unindexed field that will take time ;)[/quote'] Hmmm... So you're 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 Quote
kejpa Posted September 20, 2005 Posted September 20, 2005 Correct! You should always keep an eye on your search queries and optimize the indexes. There's a HUGE difference in response time (we're 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 Quote
EFileTahi-A Posted September 21, 2005 Author Posted September 21, 2005 Ok, thank you very much kejpa :) Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.