Re: Table partitioning question

From: Sebastiano Pilla <etechweb_at_yahoo.com>
Date: Fri, 6 Dec 2002 20:10:50 +0100
Message-ID: <1fmqu0c.17v4o3h1ybspq8N%etechweb@yahoo.com>

Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de> wrote:

> If you enter "Gelbrich" as a name, the LOV comes up fast since the name is
> rare,
> but if You enter "Smith", You receive 1000 names ... that is the real
> problem.

Have you investigated network traffic conditions? I don't know the Forms architecture, but it may be possibile that the LOV generation is pulling out a lot of network traffic for common names like "Smith". That could be a significant factor in the slowness you're experiencing.

Sebastiano Pilla Received on Fri Dec 06 2002 - 13:10:50 CST