[Vtigercrm-developers] A challenging problem for you guruvtigerdevelopers out there

[Andrew Rodes]

One more piece of information that might matter is that on the “fast”
instance, im running PHP Version 5.1.2, and on the “slow” one its PHP
Version 5.2.3. However I've been googling this for a few days, and cant find
any bug in the later version of php that may be causing it.

Thanks again for any help!

Andy


________________________________________
From: Andrew Rodes [mailto:arodes at onweald.com] 
Sent: Saturday, January 12, 2008 6:42 PM
To: vtigercrm-developers at lists.vtigercrm.com
Subject: Re: [Vtigercrm-developers] A challenging problem for you
guruvtigerdevelopers out there

Sure .. here they are.

I have continued to debug, and internally php sees it as an object but when
I log->debug it using the internal debugger it prints it like a string in
one case and “Object #40” (a reference to an object) in the other.
In popup.php 
. 
      $result = & $this->database->Execute($sql);
      $log->debug('type result from query : '.gettype($result)); //LOGS
 ‘object’ in logfile
      $log->debug('result from query : '.$result); //LOGS .long list of
comma separated data from the query(all records) on slow instance, returns
“object #40” in fast instance

As for OS .. the slow one is running on windows server 2003, the faster one
on windows 2000.

Thanks!

Andy

________________________________________
From: Prasad [mailto:prasad at vtiger.com] 
Sent: Saturday, January 12, 2008 12:58 PM
To: vtigercrm-developers at lists.vtigercrm.com
Subject: Re: [Vtigercrm-developers] A challenging problem for you guruvtiger
developers out there

Hi Andrew,

Could you please bundle the configuration files (php.ini, my.cnf/my.ini) of
both the installation separately and send it across to this thread. 

Are you having the 2 vtiger environments on the same OS? 

It would help our developer community to analyze the issue further.

Regards,
Prasad
vtiger Team
On 1/12/08, Andrew Rodes < arodes at onweald.com> wrote:
Ok , I have 2 vtiger environments in question. From what I can tell they are
very similar expect for point release difference of apache 2.2 ,  mysql 5.0,
and php 5.2
 
 
The have basically the same php.ini, mysql.ini and http.conf
 
The weird part is that one one environment pop up lists are taking 4 times
longer to load then the other. For example, when creating a new trouble
ticket, if you pop up the contacts list to select a contact, it takes 12-15
seconds, on the other environment its 3-4. (same exact database 
 number of
records etc)
 
I turned on debugging and found out a very weird thing that looks like it
might be some php or mysql  setting, but I cant figure it out quick enough.
 
 
In popup.php, there is a line of code that assigns a variable to the result
of a mysql query. However, in one environment it returns the entire list of
records, and in the other environment it returns just an object reference.
WHY would it be returning different result data types. Any ideas?
 
 
$list_result = $adb->query($query);
 
Environment 1 debugging: (very slow) (the parameters for
getSearchListViewEntries are
($focus,"$currentModule",$list_result,$navigation_array)
 
DEBUG contact_list - Entering
getSearchListViewEntries(Contacts,Contacts,firstname,lastname,title,accounti
d,email,phone,smownerid,crmid ..ect etc etc for 500+ lines in debug log with
the rows of data
 
Environment 2 debugging (fast)
 
DEBUG contact_list - Entering
 getSearchListViewEntries(Contacts,Contacts,Object id #40,Array) method ...
 
Any ideas???

_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com