[traceMe]

i have large database with 4500 records in it iam using sql as db and asp for searching for particular record from it. i have three different loop for displaying the records in proper manner..
PROBLEM
asp page takes 5 min to show me 7 records from the db...
any suggestions for making it more faster
but not affecting the table sturcture where the data is displayed.
pls mail me suggestions in forum and my hotmail a/c
"raj_silverprod@hotmail.com"

[my2cents]

Originally Posted by traceMe

i have large database with 4500 records in it iam using sql as db and asp for searching for particular record from it. i have three different loop for displaying the records in proper manner..
PROBLEM
asp page takes 5 min to show me 7 records from the db...
any suggestions for making it more faster
but not affecting the table sturcture where the data is displayed.
pls mail me suggestions in forum and my hotmail a/c
"raj_silverprod@hotmail.com"

Can you post a sample of the db access module?

[traceMe]

my problem is the code has three different loops because of which execution is taking to much of time.
i have got a idea if it works thats great
thx for ur help.