TheFlip Posted August 14, 2003 Posted August 14, 2003 What's the maximum number of records that can be inserted into a database table? Is there a limit I should keep it at? Is there a point at which the time to run a query becomes too noticable? Better yet, how many records would have to be in the table for a query to take more than 3 sec.? 5 sec.? TIA! Quote
TCH-Sales Posted August 14, 2003 Posted August 14, 2003 If I were you I'd keep it at a reasonable level. Not so much that it would draw too much processing to get it done, but not so little that you can't get what you need to do done. Quote
surefire Posted August 14, 2003 Posted August 14, 2003 I think that the way you structure your query will have a lot to do with how fast it runs. In other words, it's a lot faster to have a long, drawn out, selective query that eliminates most of the records in your table, than to have a query that selects almost every row of a long table and then the rest of your script selects the stuff you need. I'm not sure that was such an eloquent explanation... but learn as much as you can about queries and joins. If you write the query with care, even very large tables should be parsed in under three seconds. Quote
TheFlip Posted August 18, 2003 Author Posted August 18, 2003 I got hit with the Blackout, couldn't reply until I got back to work. Great advice, thanks. It should help. Thumbs Up 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.