sql server - PHP with MSSQL performance -

i'm developing project need retrieve huge amounts of data mssql database , treat data. data retrieval comes 4 tables, 2 of them 800-1000 rows, other 2 55000-65000 rows each one.

the execution time wasn't tollerable, started rewrite code, i'm quite inexperienced php , mssql. execution of php atm in localhost:8000. i'm generating server using "php -s localhost:8000".

i think 1 of problems, poor server huge ammount of data. thought xampp, need server can put without problems mssql drivers use functions.

i cannot change mssql mysql or other changes that, company wants way...

can give me advices how improve performance? server can use improve php execution? thank in advance.

the php execution should least of concerns. if is, going things in wrong way. php should doing running sql query against database. if not using pdo, consider it: http://php.net/manual/en/book.pdo.php

first way sql query structured, , how can optimised. if in complete doubt, try posting query here. aware if can't post single sql query encapsulates problem you're approaching problem wrong angle.

i assuming post not have recourse alter database schema, if second course of action.