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

[Prasad]

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,accountid,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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20080113/70d3e090/attachment-0003.html