Hi,
If you want to load 22,000 records into your client, it will always take
time.
Would it not be possible to limit the selection?
If you are loading all records, indexes are not important, as everything
must be read anyhow.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
