By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,913 Members | 1,379 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,913 IT Pros & Developers. It's quick & easy.

How could i make my Website faster

syedshaffee
P: 91
Hey people,

i need help I am created a website that is a information system That gives information to my clients. Can some please suggest me to speed up the search process b'coz at some point i'm getting "SQL Server timeout expired "

while getting a the data on a temp table The data is visible when refreshed so Please help on the same Please

This is the query i am using

Expand|Select|Wrap|Line Numbers
  1.         sql = " SELECT isnull(userdatacomment,'NONE') as comment, Asset_Detail.Asset_serial_no,Asset_Detail.Asset_id, " &_
  2.               " Asset_Detail.Asset_barcode_no, " &_
  3.               " Asset_Detail.Asset_description, Asset_Type.Asset_type_description, " &_
  4.               " assettypesub.assettypesubdesc, " &_
  5.               " Asset_Detail.Asset_contract_no,Asset_Detail.Asset_Rental,Asset_Detail.Asset_type_id, " &_
  6.               " state.statedesc,Asset_Detail.Asset_purchase_date,Asset_Detail.Asset_PO_no, " &_
  7.               " isnull(Asset_Detail.Asset_purchase_price,0) Asset_purchase_price," &_
  8.               " Supplier_Detail.Supplier_Name, invoice.invoice_date,Invoice.Invoice_no, " &_
  9.               " Customer_User.User_Name,Customer_User.User_code,Cost_Centre.Cost_Centre_Code,Cost_Centre.Cost_Centre_Description, " &_
  10.               " Department.Department_Code, Department.Department_Desc " &_
  11.  
  12.               " FROM Asset_Detail left JOIN user_data on userdataassetid = asset_detail.asset_id " &_
  13.               " inner join Contract_detail ON Asset_Detail.Asset_contract_no = Contract_detail.Contract_no " &_
  14.               " left JOIN Department ON Asset_Detail.Asset_Department_Id = Department.Department_Id " &_
  15.               " left JOIN Customer_User ON Customer_User.User_Id = Asset_Detail.Asset_User_Id " &_
  16.               " left JOIN ( select * from Cost_Centre where Cost_Centre_Active <> 0) Cost_Centre ON " &_
  17.               " Cost_Centre.Cost_Centre_ID = Asset_Detail.Asset_CostCentre_Id " &_
  18.               " LEFT JOIN Invoice ON Asset_Detail.Asset_invoice_id = Invoice.Invoice_id " &_
  19.               " left JOIN state ON asset_detail.asset_TO_stateID=state.stateid " &_
  20.               " LEFT JOIN Asset_Type ON Asset_Detail.Asset_type_id = Asset_Type.Asset_type_id " &_
  21.               " LEFT JOIN AssetTypesub on Asset_detail.asset_subtype=assettypesub.assetTypesubId " &_
  22.               " LEFT JOIN Asset_Category ON Asset_Category.Asset_category_id = Asset_Type.Asset_type_Category_id " &_
  23.               " LEFT JOIN Supplier_Detail ON Invoice.Invoice_supplier_id = Supplier_Detail.Supplier_id " &_
  24.               " WHERE Contract_detail.Contract_customer_id = " & Session(CUSTOMER_ID) & _
  25.               " AND ISNULL(Asset_Detail.Asset_Active,0) <> 0 AND Asset_Type.Asset_type_id IN(131,135,132,95,99,66,101,102,145,310)AND Client_Intent_Date IS NULL AND Client_comments IS NULL " 
  26.  
Jul 11 '12 #1
Share this Question
Share on Google+
4 Replies


Rabbit
Expert Mod 10K+
P: 12,369
That depends on the table structure and the query you're using. It doesn't sound like it has to do with the website itself.
Jul 12 '12 #2

100+
P: 185
Try to add some caching capabilities to your application. For a request to be cached, always use get method in the form.
Jan 5 '13 #3

Frinavale
Expert Mod 5K+
P: 9,731
You could consider using a store procedure if you aren't already...

Stored procedures are precompiled so they don't need to be compiled during execution.

-Frinny
Jan 8 '13 #4

P: 1
HI
This Is most frequent problem that we all are facing today's scenario.You I Would like to tell you that just refresh your all sets and get it all connection in right position so that you can improve yous website speed.
Thanks.
Jan 28 '13 #5

Post your reply

Sign in to post your reply or Sign up for a free account.