how to optimise SQL server data access while coding in ASP?

Question

i have to code for www.yellowpagesindia.info for getting search result . Im coding in asp how to optimise the data access while calling a database . My database is SQL server.

Answer 1

Optimizing the Data Access depends on

#1) Database Design
#2) DDL (Data Definition Language)
#3) ASP coding (How you hold the data at the client/server side and show them on the web page)

#1 is the must, If #1 is not proper, then use #2 at your best level where calling Stored Procedures and Writing well built SQL statements to fetch data from more than one table) and at #3 use "Command" object for executing SP and hold it in disconnected recordset, and open with proper cursor. So data access will be faster then compared to raw (other childish coding). Just give a try on this part.

If the arc is 3-tier then this can be done in much optimized way that depends on your responsibility. If you are alone programmer then change #1, #2 and #3, if not, then you can work by yourself at #2 and #3 level in better way.

Hope this helps.

Answer 2

You don't optimize data access at the time of running your queries, you do it through proper design of your database in the first place, well before you start asking for data.

http://www.databasejournal.com/features/mssql/article.php/1466951

And a note to all the other questioners out there, especially from India, where the use of antique tools is prevalent: PROVIDE VERSION NUMBERS!

If you say you are using ASP, we don't know if you mean ASP 3, ASP.NET 1, ASP.NET 2 of ASP.NET 3 / Atlas. There are huge differences between SQL Server 200 0 and SQL Server 2005, too. If you don't give versions, we have no way of knowing whether our answers will be correct for your needs.

Answer 3

Yellow Pages in India have hired a programmer who doesn't know how to optimise data access ? I don't believe it.

Answer 4

i think of you have hearth walled your self out of the server. domicile windows XP firewall or the different firewall you have 2 techniques, --- disable firewall (Use this to attempt first) --- configure firewall to helps sq. server port open. sq. server helps connection over TCPIP / Named pipe. TCPIP connection is common to configure over firewall. one greater factor the domicile version of sq. server helps in basic terms one consumer connection at a time. So in case you're finding to to connect greater beneficial than one consumer that ought to be one in each and every of different issues. Get a universal version of sq. server 2005 with new seen studio this is a 5 consumer reproduction.