Interesting. Maybe it is slow because of the sorts with the returned blob fields? Why don't you just make a stored procedure with a for..select query to return the primary keys of the tables you are interested in and inside the for pull out the blobs and rest of the data?
-steve -- Steve Wiser President Specialized Business Software 6325 Cochran Road, Unit 1 Solon, OH 44139 www.specializedbusinesssoftware.com www.docunym.com (440) 542-9145 - fax (440) 542-9143 Toll Free: (866) 328-4936 On Thu, Aug 11, 2011 at 11:31 AM, red_october2009 < [email protected]> wrote: > ** > > > Here is some further info: > > I have been experimenting by eliminating JOINed tables, and fields that > pull from tables in the JOIN. > > If I pull back only fields from s then the execution time is fast. As I add > VARCHAR() fields from the JOINed tables, execution slows, but is still > acceptable (< 2 seconds). > > However when I add BLOB SUB_TYPE 1 fields from the JOINed tables, it kills > the response time... up to 9 seconds. > > Pulling back BLOB fields seems to be the hold up. However, I need those > fields. Is there a way to make the blob fields in the query not so damaging > to response time? > > > > > This message and any files transmitted with it may contain information that > is privileged, confidential, and exempt from disclosure under applicable > law. They are intended solely for the use of the intended recipient. If > you are not the intended recipient, distributing, copying, disclosing, or > reliance on the contents of this communication is strictly prohibited. If > this has reached you in error, kindly destroy this message and notify the > sender immediately. Thank you for your assistance. > > We attempt to sweep harmful content (e.g. viruses) from e-mail and > attachments, however we cannot guarantee their safety and can accept no > liability for any resulting damage. The recipient is responsible to verify > the safety of this message and any attachments before accepting them. > [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
