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 <[EMAIL PROTECTED]> 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.
