Hi,
I am using PHP's PDO functions to retrieve data from an Oracle database. My query is a simple select statement on a large table (nearly 2.5 million rows and 15 columns) with a where clause and takes less than 1 sec. However, when using PDO::Fetch to get a result set of about 100 + rows, the function seems to take nearly 20 sec. It doesn't really seem to matter as to how many results are fetched. When I try to fetch data from smaller tables the function seems to take normal times (less than 1 sec). Shouldn't the function time really be dependent on the results as opposed to the table being queried?
Thanks!
