This is a combobox inside a form. The problem is that is grabs from a table with about 40,000 records, which is probaly pretty silly. Is there a way I can optimize this. Maybe with a stored proc, would that help any? Any suggestions would be appreciated.


<%
SET rs = server.CreateObject("ADODB.RECORDSET")
rs.Open "SELECT ps_Id AS Value, Ps_CodFab AS Nombre FROM TbNvLpPsMaestroGrl ORDER BY Ps_CodFab", conn, adOpenStatic, adLockReadOnly
%>



                <TD class=DetalleTitulo>&nbsp;Componente</TD>
                <TD class=DetalleDato>
                <SELECT id="Cmb1" name=ps_Id tabindex="3">
                <OPTION value="">Componentes</OPTION>
                <%Do While Not rs.EOF%>
                <OPTION value="<%=rs.Fields("Value")%>" <%If Trim(Request.QueryString("ps_Id")) = Trim(rs.Fields("Value")) Then%>selected<%End If%>><%=rs.Fields("Nombre")%></OPTION>
                <%rs.MoveNext
                Loop%></SELECT>


<%
rs.Close
set rs = nothing
%>

Is there any logical filter that can be applied before creating the dynamic combo list

\John

Hi there,

IMO, the problem is not necessary with the performance. I think you're not going to fix this with a sproc. That is, it might be faster than it is now, but IMO you should reconsider your design.
Your users are not going to be happy when you present them with 40,000!! items in a drop-down.....

How about a smarter interface, like a search box where they can narrow down the list?

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Well I created a search list with filters and stuff. Your right!