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

[Andrew Rodes]

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 <mailto: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
<http://jobs.vtiger.com> 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20080112/f88dc5fd/attachment-0003.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: my.ini
Type: application/octet-stream
Size: 416 bytes
Desc: not available
Url : http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20080112/f88dc5fd/attachment-0012.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: php.ini
Type: application/octet-stream
Size: 39360 bytes
Desc: not available
Url : http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20080112/f88dc5fd/attachment-0013.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: php_slow.ini
Type: application/octet-stream
Size: 49378 bytes
Desc: not available
Url : http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20080112/f88dc5fd/attachment-0014.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: my_slow.ini
Type: application/octet-stream
Size: 8877 bytes
Desc: not available
Url : http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20080112/f88dc5fd/attachment-0015.obj