May 5, 2003 at 12:36 am
Is there a way for me to speed up the data display if the database is very large??
and is there a way where I don't always have to change the database file cause this webpage I am developing are for lots of different database and My supervisor ask me to come up with a way to avoid them to change it manually through the codes..
eat when you can and not when you cannot.
eat when you can and not when you cannot.
May 5, 2003 at 4:20 am
If you mean can you access other databases without having to disconnect from one and connect to another the answer is yes. As long as they have proper permissions the code can reference the qualified name like
SELECT * FROM DBName.ObjectOwner.ObjectName
If you mean can you create a connection in such a ways as to be generic on any server the answer is yes. When the user is created on the server make sure their default DB the the one that the Web app needs to connect too. You don't have to enforce name then.
Next define the connection using a defined ODBC entry or a Name entry in SQL Client Network Utility, then you can just use the same named object for the conector and that is all that has to be configured on the server.
----------------------------------------
As for spedding up the data display this depends on many factors. 1 make sure the only data being pushed down even if not displayed is what they need to be able to perform the task at hand. So if they see 8 of 50 column and 2 are used behind the scenes then only SELECT the 10 columns needed for the job not all 50.
Also make sure indexes cover the data and queries properly. Beyond that it is tweaking and playing to find what works best. Check out hints in the Articles here and checkout http:///www.sql-server-performance.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply