Inventory Search Screen Issue

[Alex D. Fleming]

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.

[David E Jones-2]

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.

[Alex D. Fleming]

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 <[hidden email]> 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.

[Cameron Smith-6]

Hi Sam, do you mind if I ask if you have gone into
production with this stack yet? (Win2003/MSSQL 2000).
The reason I ask is, we are comfortable with Ofbiz on
Linux/MySQL but we have one client who would prefer it
on Win/MSSQL.  However, I was a bit concerned about
recommending this option, because I had not seen
anyone using it in production or for anything serious.

So if you could give me even a brief summary of your
good and bad experiences with this platform, I would
very much appreciate it.

cheers,
cameron

--- "Alex D. Fleming" <[hidden email]> 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 – Tired of Vi@gr@! come-ons? Let our SpamGuard protect you. http://uk.docs.yahoo.com/nowyoucan.html

[BJ Freeman]

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 <[hidden email]> 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.