Re: Resource limit/performance questions

Well, the execution time depends on a number of factors. If your tables are indexed properly and you take advantage of the indexes, then the growth in execution time is not linear (I'm guessing the indexes are maintained through balanced or semi-balanced trees or a similar method). However, in your case, it's not the execution time but the number of executions. Even under the best of circumstances, if the number of queries increases in relation to the number of records, then you will notice a proportional slowdown. If the queries do not use your indexes, then the slowdown will probably be geometric, since the SQL engine will have to spend more time sorting through the records for each query. I usually say queries... it's worked so far :-) Marco -- ------------ php|architect - The Magazine for PHP Professionals The monthly magazine dedicated to the world of PHP programming Check us out on the web at http://www.phparch.com!