dbTalk Databases Forums  

Poplist size

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Poplist size in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
papalphaus@yahoo.com
 
Posts: n/a

Default Poplist size - 07-18-2007 , 01:54 PM






I am dynamically populating a poplist with a query based upon
username. Is there a limit (quantity or memory) on how big the
poplist can be? If it is, is it a parameter that can be modified at
the server or some other level?


Reply With Quote
  #2  
Old   
Brian Peasland
 
Posts: n/a

Default Re: Poplist size - 07-18-2007 , 02:58 PM






papalphaus (AT) yahoo (DOT) com wrote:
Quote:
I am dynamically populating a poplist with a query based upon
username. Is there a limit (quantity or memory) on how big the
poplist can be? If it is, is it a parameter that can be modified at
the server or some other level?

That limit (if it exists) is in your application server, not Oracle.
Oracle will returns millions and millions of rows for the query if the
query warrants it. The better question is, can my application server
handle this and does my development platform handle this? In any case,
that is not an Oracle question so another forum might be better suited
for you.

HTH,
Brian


--
================================================== =================

Brian Peasland
dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com



Reply With Quote
  #3  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: Poplist size - 07-19-2007 , 03:31 AM



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

papalphaus (AT) yahoo (DOT) com wrote:
Quote:
I am dynamically populating a poplist with a query based upon
username. Is there a limit (quantity or memory) on how big the
poplist can be? If it is, is it a parameter that can be modified at
the server or some other level?

No, but there are guidelines to GUI design. One of them
explains what the options are when a poplist gets too long.

The (well-known) poplist with countries of the world is
a prime example of a list which basically is too long.

There should be a pre selection screen (e.g. continent); but
because everyone uses the shortcuts (start typing), there's
no burden.
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGnyFGLw8L4IAs830RAuHjAJ9B1otqnxd3/8ZxkcpPCoeZGYpusACdEQuJ
Z/iiqHBBGtm/Al/J2RlgNUg=
=xvv2
-----END PGP SIGNATURE-----


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.