ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From BJ Freeman <bjf...@free-man.net>
Subject Re: Inventory Search Screen Issue
Date Fri, 06 Oct 2006 02:19:26 GMT
I would use the profiler in the sql server.
see what is going on between the ms-SQL SERVER and ofbiz

Alex D. Fleming sent the following on 10/5/2006 3:39 AM:
> Thx for the reply David.
>  Actually I was trying to find the Inventory Item from the default Inventory screen provided
in Ofbiz.(Facility -- > Inventory).
>  
>  Wide search means -- when I didn't give any search criteria and clicks on the 
> "Find" button then the screen sometime returns records after long time  
>   And most of time it returns Error.
>  
>  Thx
>  Alex D. Fleming
>  
>  
> David E Jones <jonesde@undersunconsulting.com> wrote: 
> What do you mean by "Wide search", or in other words which screen or  
> request are you using?
> 
> It may be that you've found some code that is not written to properly  
> handle large volumes of data, or in other words using the  
> EntityListIterator and such.
> 
> -David
> 
> 
> On Oct 5, 2006, at 11:22 AM, Alex D. Fleming wrote:
> 
>> Hi,
>>
>>  Hi,
>>      I have Ofbiz running on Windows 2003 server with SQLServer  
>> 2000 for database. There are about 7000 inventory Items.If make a  
>> Wide search, The screen sometime returns records after long time  
>> And most of time it returns Error.If I provide ProductId then it  
>> works fine.
>>
>>  Do I need some kind performance setting that may be missing?
>>
>>  Thanks in advance.
>>  Alex D. Fleming
>>
>>    
>> ---------------------------------
>> How low will we go? Check out Yahoo! Messenger’s low  PC-to-Phone  
>> call rates.
> 
> 
> 
>  		
> ---------------------------------
>  All-new Yahoo! Mail - Fire up a more powerful email and get things done faster.


Mime
View raw message