• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Search results in an out of memory exception
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Search results in an out of memory exception


  • Subject: Search results in an out of memory exception
  • From: David Holt <email@hidden>
  • Date: Mon, 25 Oct 2004 10:17:18 -0700

I have just upped my test database of documents from 1500 records to 17,000. I have a WOComponent with a WODisplayGroup and the appropriate qualifier fields for searching. If I qualify the data source by putting a value in one of the search fields I get a list of documents as expected. If I submit the form without information in any of the qualifier fields (this used to return the whole data set divided into paged results), I get the following exception from the application after a minute or so of waiting:
Error:
com.webobjects.foundation.NSForwardException [java.lang.OutOfMemoryError] null

It is a MySQL database, WO 5.2.3, OS X Server 10.2
I have a blob field that holds the text content of the documents (for searching) as well as a URL field pointing to the original document on the file system. One of the qualifier fields is used to search the content field.

Three strategies I can think of to fix the problem are:
1. Increase system memory (not a good long term solution as the documents will grow over time)
2. Put the blob field in a separate table so it is not loaded with the WODisplayGroup (not sure if I can still do searches on that field if I do that)
3. Get the content out of the database and use a combination of PDFbox and Lucene to provide the content searching separate from my database.

What would you suggest is the best strategy? Or have I misidentified the problem?

Thanks,
David

--
It's like driving a car at night. You never see further than your headlights, but you can make the whole trip that way.

E. L. Doctorow

<x-tad-smaller>from Sunbeams: http://www.thesunmagazine.org</x-tad-smaller>
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: Search results in an out of memory exception
      • From: Chuck Hill <email@hidden>
    • Re: Search results in an out of memory exception
      • From: Jean-François Veillette <email@hidden>
    • Re: Search results in an out of memory exception
      • From: Ray Ackland <email@hidden>
  • Prev by Date: Re: NSDictionary & KVC problem
  • Next by Date: Re: Search results in an out of memory exception
  • Previous by thread: Re: NSDictionary & KVC problem
  • Next by thread: Re: Search results in an out of memory exception
  • Index(es):
    • Date
    • Thread