Originally Posted by smritisingh03
I have to run a simple query-
Select count(*) from $table_name;
this has to run on 50000 tables in DB.it is taking too much time...so i thought of doin // execution to improve the performance...could someone guide me as to how can i run this query in // for say 10 tables at a time...any suggestions in highly appreciated.
Well, you don't say what kind of SQL database you're using, version/distro of Linux, and what language you'd like to write this script in, so we can't help you. Provide details, and perhaps we can help.