Performance Problem

The Webscribble Webdate Users Lounge. This Forum Is For Webdate Site Owners To Talk About Anything Other Than Bugs. Share Experience. Find Partners Or Anything Else.

Performance Problem

Postby hatty1 on Thu Nov 19, 2009 3:28 pm

Hi All,

Anyone on Webdate3 with 8000 + profiles. I am bit confused why it's so slow.
I upgraded from 2 to 3. My Dev env is windows vista with 2 G RAM. Clicking index page
on Webdate 3 is consuming more than 70 percent of CPU res.

I did indexing as suggest by paul. No improvement.

Paul, please could you suggest any solution?

Thanks!
H
hatty1
 
Posts: 3
Joined: Sat Oct 24, 2009 4:55 pm

Re: Performance Problem

Postby paul on Sun Nov 22, 2009 8:11 pm

This is an issue with the featured profiles

the script runs way too slow

you can take it out by going into

engine/pages/index.php

save the original code from index.php then change it to:

<?
// this files contains no code
?>


just add that into the php page and save (make sure you send it up to the server)

but if you need the featured profiles you can cut back the search so it only looks in 1000 of the members instead of the full 8000

Paul
User avatar
paul
Site Admin
 
Posts: 264
Joined: Sat Jan 26, 2008 7:30 pm
Location: Newington,Ct,USA

Re: Performance Problem

Postby hatty1 on Wed Nov 25, 2009 1:52 pm

Great Help! Thank you!
Worked like rocket

Making index.php blank was returning blank page. Quick search is called there.
Here are the final contents:


$quick_search_gender = sysGetValSelect(search_gender, dt_genders, 0, "Male");
$quick_search_looking_for = sysGetValSelect(search_looking_for, dt_genders, 0, "Female");

$quick_search_age_from = sysGetNumberSelect(search_age_from, 18, 55, 0, 18);
$quick_search_age_to = sysGetNumberSelect(search_age_to, 18, 80, 0, 25);

parseVariables("templates/index.html");



Now trying to limit feature profile. I need that. Will post if sucessful.

Thanks
H
hatty1
 
Posts: 3
Joined: Sat Oct 24, 2009 4:55 pm

Re: Performance Problem

Postby paul on Wed Nov 25, 2009 11:12 pm

this is what I did

Code: Select all
$search_query = "SELECT p.id, p.gender, p.name, p.sgroup, p.general_info, m.age, f.filename_1 FROM (dt_profile p, dt_photos f, dt_members m, dt_privacy pr) WHERE (p.id<='200' and p.status='1' AND p.member_id=m.id AND f.member_id=m.id AND f.filename_1<>'' AND p.gender='$genders[name]') ";


the p.id<='200' is the part that would only search for people with profile id of less than 200 you can adjust the number a bit

Paul
User avatar
paul
Site Admin
 
Posts: 264
Joined: Sat Jan 26, 2008 7:30 pm
Location: Newington,Ct,USA


Return to Webdate Users Lounge

Who is online

Users browsing this forum: No registered users and 5 guests

cron