Re: Speed/time of readung information from database

a> My problem is speed/time of reading information from database. I use T1 and it's not a a> big problem, but for client (magazine), who has DSL, it's pain in the neck to see in admin a> pages listing with a> e.g. 2000 subscribers. Result is very often frozen computer. a> What's solution? a> I don't have a lot of experience with PHP and MySQL and maybe I made problem with a> "my way of coding". Maybe I have consider about something I do not?!? It sounds like you are attemping to display 2k of subscribers to a single page. If this is the case then I would suggest putting a <previous><next> set on your page and LIMIT the number of items on a single page (using mysql LIMIT). That way you can get a hit of 20, 25 (or whatever you decide) at a time. The other method would be to give the user the ability to look at the subscriber list according to alpha character. For example display 'a b c d ..' and href it to a page/select for all subscribers with lname like 'a%' (or something similar). -- DSig David Tod Sigafoos mailto:dsig@teleport.com Using 'The Bat' 1.48f ````` ( O O ) _______oOOo__( )__oOOo_______