Php script performance control

Question

I am building a web site and want to provide public API to everobody without registration. The api will perform search function, and as database is big it will consume a lot of resources. So I want to seriously limit memory, process time, ect. Also I will use public hosting (non personal or dedicated), so I will not have any access to process control (I suppose). What do you recommend to do?

I think of using one global variable that will store last successful script executing time and will terminate script if enquery is more than in 1 sec. I was not able to find super global (across all scripts) variables, so will use file with lock on it.

But anyway, any php script execution control???

Have you considered caching ...You should think of database indexing as well and if your api's are going to be open for the public, you should also ensure you don't get any spam or sql injection.. so either create api keys or think of some form of captcha.. — omar-ali
– omar-ali, Commented Dec 9, 2013 at 17:49
Search is by index, but it is near 20k rows. Database is fine. Sql injection will be blocked as only simple words are allowed for a search. Spam - no reason how it can be used. I do not think of API keys, but anyway I will have same problem: "How to limit" — Tigran
– Tigran, Commented Dec 9, 2013 at 17:58
Have you done any performance testing? How do you know that your queries will take a long time and/or consume memory? 20K rows isn't "big" for MySQL, unless you have a really bad design with hundreds of columns, no indexes, inefficient column types, etc. — Dave
– Dave, Commented Dec 9, 2013 at 19:11

omar-ali · Accepted Answer · 2013-12-09 17:55:20Z

3

I guess you can control it by php_ini in global configuration, or ini_set() inside the script, by setting memory_limit and max execution time.

Here's a link to the php configuration file manual

PHP configuration file

edited Dec 9, 2013 at 17:55

omar-ali

5174 silver badges14 bronze badges

answered Dec 9, 2013 at 17:49

arekstasiewicz

3832 gold badges11 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tigran Over a year ago

Can it be set for 1 script only, or it will affect everything?

omar-ali Over a year ago

Ah, good point. It'll affect everything. Try this: hk2.php.net/ini_set The answer above mentions ini_set() .. I do advice you to look at the answers provided in detail to benefit in max without expending the helper's resources :) And you should definitely mark his answer as correct!

Collectives™ on Stack Overflow

Php script performance control

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related