Hello friends

I m working in PHP with my backend as Mysql. I face a peculiar problem while retrieving records from the database, when the dump is more. Whts tht is..when i try to retrieve more than 15000 records @ a time....the link is going to err page but the same piece of code works for less than 1000 records. i need help regarding the same and how to improve the performance..

Thanks to u in advance

: Hello friends
:
: I m working in PHP with my backend as Mysql. I face a peculiar problem while retrieving records from the database, when the dump is more. Whts tht is..when i try to retrieve more than 15000 records @ a time....the link is going to err page but the same piece of code works for less than 1000 records. i need help regarding the same and how to improve the performance..
:
: Thanks to u in advance
:


why not just do it in pieces?

Can we see the actual query? (or a likeness of it)
Snoochie Boochies

this is one of the option so v can not do it in pieces

select TestCaseId,master_caserefs.master as TestName,users.name as TestEngineer,testcase_testengineer.status as Status,testcase_testengineer.pass,testcase_testengineer.relid,ActualDuration,testcase_testengineer.testenddate as TestEndDate,sub_area_name,TestAssgnId,naviscorestatus,ResultComments,niemsstatus,pass.PassName ,master_caserefs.test_desc as TestCaseDescription from testcase_testengineer,atsLogin.users,master_caserefs,master_arearefs,pass where testcase_testengineer.TestEngineer=atsLogin.users.user_id and testcase_testengineer.pass in(177) and testcase_testengineer.relid="9" and testcase_testengineer.TestCaseId=master_caserefs.id and master_caserefs.area_id=master_arearefs.sub_area_id and area_id in and testcase_testengineer.status REGEXP "^.*" and testcase_testengineer.pass=pass.PassId order by master_caserefs.master

Hi ,
Do u think i need to modify php.ini config file?
If So then which environmetal variable i need to modify do u have any idea about these?
Thank u

Yes im sure there is a configurable variable in the ini file that allows you to retreive more rows.. it shouldn't be hard to find..

But keep in mind, there is only so much ram the server has, and retreiving THAT many rows could be bad :P
Snoochie Boochies

maybe the records exceeded the RAM size in your php.ini file,, check it and increase it and don't forget the actual size of your RAM, it'll yiel with error.....

dede