Re: Terrible performance when deployed to GAE

It's actually happening right now.

http://1-0-3.pr ofe val3.appspot.com/Search?searchText=crawford  (without the spaces )

Took 7.29 seconds (after the app had already started up previously)

The SQL instance is : pr ofe val-db:pr ofe val-db  (without the spaces)

The Query

use pro feval;  (without the spaces)

select distinct * from (select match(p.fullname, p.schoolname) against('crawford') as score, p.professorId, p.schoolId, p.lname, p.fname, p.schoolName, p.ID,r.id as regionId, r.name as regionName, 'p' as searchtype

  from final_professors p, schools s, regions r

  where match(p.fullname, p.schoolname) against('crawford')  

  and p.schoolID  = s.id and s.regionID = r.id limit   0 , 41) a

  union

  select distinct * from (select  match(s.name) against('crawford') as score,0 as profesorId,s.id as schoolId,'' as LName,'' as FName,s.name as schoolName, 0 as ID,r.id as regionID, r.name as regionName, 's' as searchtype

  from schools s, regions r where (match(s.name) against('crawford') and s.regionID = r.id)  limit  0 , 41)b

  order by score desc;

From the console: 

Feb 1, 2012 12:45 PM (18 ms)

Any help would "greatly" be appreciated.

- Derrick