Hi all,
Could anyone give me the optimized solution for my query

I have table called Appl_tbl with 4 columns

    ENo eName ecopies category


I need to display the data from tha above mentioned table.
depends upon the category I need to display static Heading

category are mgr,acc,clr,trn and are fixed
if mgr means "The List holds the details of mgr and their ......"

here i wrote the code like
dim Rs=server.createobject("ADODB.RECORDSET")

sub GetDetails()
strSql="Selec..... from tbl"
set Rs=objcon.execute(strSql)
end sub

'pass the recordset

sub displayMgr(rs)
rs.filter = " category= mgr"
if not rs.eof then

'display the static message

while not rs.eof
  response.write rs(0) & "-" rs(1)
 rs.movenext
wend
end if
end sub

like the above sub i wrote 3 sub for categories and filter the category and displayed
is that code optimized or wat else i should do for performance and readability
Love
Deepak

Hi

What database are you using? I would sugest using a where clause in your query. e.g strSQL = "Selec..... from tbl Where category = 'mgr'" and then make sure the category field is indexed by your DB Server. Selecting all data from a table without a where clause usually results in in DB server having to do a full table scan to return all the data. Query optimization should be done on DB/Table level according to your application queries.

Hope this helps.

Regards
Marnus