Posts: 2,904
Threads: 59
Joined: Jun 2010
I tested the existing method and the two new solutions and they all took around 0.5 seconds for me, so I will stick with the existing method (unless I hear back from you).
Have
you completed
the interview?
Posts: 21
Threads: 6
Joined: Feb 2012
We are still testing and adapting, since I am part time working in shifts and part time self employed sometimes I run out of time.
We auto populated the pages and comments database with 2 small php files I created.
Front ent of the websites reacts really nice at this moment. I still need to test your code, will do that today and report to you.
I will post the two import files with instuctions somewhere in the forum for other users with dynamic large sites.
Posts: 21
Threads: 6
Joined: Feb 2012
Ok Steven,
Testing your code:
Solution 1 takes 7 seconds for the page to be loaded and stored in db
Solution 2 takes 10 seconds for the page to be loaded and stored.
Also you had an error in your posted code for solution 2. You ended with } and that was one to many and created parse errors.
So I will return to your original code and use the inclusion of my own php variables for the page_id to be stored.
Back to original code + own variabled takes fractions of seconds to load the page.
Thnx for the support.