I have a table with about 22,000 records. I have a unique index on 2 field on this table.
On another form I have a Character field that connects via a menu to these records. Even though I have an index, it takes a good 40 seconds for the menu item to show all of the records when activated. Is there any way to increase the performance on this? Looks like it works this way on the desktop client and the midtier. ARS 7.1 p7 Windows 2003 Oracle 10g Lisa Kemes AR System Developer TE Information Systems Global Infrastructure and Ops +01 717 810 2408 tel +01 717 602 9460 mobile lisa.ke...@te.com MS 161-43 P.O. Box 3608 Harrisburg, PA 17105-3608 [cid:image001.gif@01CC2749.FBEC6050]<http://www.te.com/> www.te.com<http://www.te.com/> [cid:image002.png@01CC2749.FBEC6050]<http://twitter.com/teconnectivity>[cid:image003.png@01CC2749.FBEC6050]<http://www.facebook.com/teconnectivity>[cid:image004.png@01CC2749.FBEC6050]<http://www.flickr.com/photos/teconnectivity/>[cid:image005.png@01CC2749.FBEC6050]<http://www.linkedin.com/groups?gid=1591657>[cid:image006.png@01CC2749.FBEC6050]<http://www.youtube.com/teconnectivity> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<<inline: image001.gif>>
<<inline: image002.png>>
<<inline: image003.png>>
<<inline: image004.png>>
<<inline: image005.png>>
<<inline: image006.png>>