Re: sql slow compared to dml qbe

Article View: borland.public.vdbase.data.sql

Article #466

Back to borland.public.vdbase.data.sql Previous Next

#466

From: Bowen Moursund (TeamB)
Date: Wed, 02 Dec 1998 00:00

12 lines
990 bytes

>takes about seconds to browse.... why.   Why is it so slow.   I fee like
>going back to dml for the speed.  Any suggestions on what I'm doing wrong.

Try linking the tables using masterRowset/masterFields rather than doing a
join. You might try processing your QBE with the QBE2DMD.PRG utility to see
if it can be easily converted.
__
Bowen Moursund (TeamB)
bowen at nerds dot com
http://lonestar.texas.net/~moursund/
Try this help resource:
http://www.dejanews.com/home_ps.shtml

Technical Details

Message-ID: <744028$qgr13@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <743gct$q096@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,b591367175fe64f8,start
X-Google-Attributes: gidff5a1,public
From: "Bowen Moursund (TeamB)" <bowenSEND_ME_NO_SPICED_HAM@nerds.com>
Subject: Re: sql slow compared to dml qbe
Date: 1998/12/02
Message-ID: <744028$qgr13@forums.borland.com>
X-Deja-AN: 417926638
References: <743gct$q096@forums.borland.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: DataTech
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message