WebProWorld Part of WebProNews.com
Page One Link To Us Edit Profile Private Messages Archives FAQ RSS Feeds  
Forum Index Search Engines Marketing Site Design IT Discussion eCommerce Center  

Go Back   WebProWorld > Webmaster, IT and Security Discussion > Database Discussion Forum
Reload this Page optimising mySQL queries
Subscribe to the Newsletter FREE!
Register FAQ Members List Calendar Arcade Chatbox Mark Forums Read

Database Discussion Forum This is the place to find help resolving those nagging questions you have about implementing and using all kinds of databases. Need help writing a query? Need an opinion on Oracle? Post here!

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 12-07-2006, 05:21 AM
James20 James20 is offline
WebProWorld New Member
  

Join Date: Apr 2006
Location: United Kingdon
Posts: 6
James20 RepRank 0
Default optimising mySQL queries
Hi i would like some pointers on optimising queries

I currently manage a site and a major flaw is the time it takes to load a page with complex queries

any tips would be grateful

Jonathan
__________________
Search Engine Optimization for Web Design, SEO, Branding and E-commerce.

Business Directory for all uk businesses.
Reply With Quote
  #2 (permalink)  
Old 12-07-2006, 09:55 AM
Dubbya's Avatar
Dubbya Dubbya is offline
WebProWorld 1,000+ Club
  

Join Date: Nov 2006
Location: Steinbach, Manitoba, Canada
Posts: 1,098
Dubbya RepRank 3Dubbya RepRank 3
Default
Hi James20,

Head over to Four Guys from Rolla for Coding Tips
__________________
Printer ink, inkjet & toner cartridges in Canada
"Price-wise printing supplies"
inkjetOasis.ca
Reply With Quote
  #3 (permalink)  
Old 01-26-2007, 06:43 AM
preferatele21 preferatele21 is offline
WebProWorld New Member
  

Join Date: Jan 2007
Posts: 7
preferatele21 RepRank 0
Default
On my site http://www.preferatele.com when a registered user want to download a .zip THROUGH redirection to doc.zip i get an error (message) from internet explorer : "Internet Explorer blocked this site from downloading files to your computer".

I would like to know if it's possible to give the doc.zip to the user without this step.
You can try to download different articles form different addresses
Reply With Quote
  #4 (permalink)  
Old 08-24-2007, 04:48 PM
marms767 marms767 is offline
WebProWorld New Member
  

Join Date: Dec 2005
Posts: 5
marms767 RepRank 0
Default Re: optimising mySQL queries
Can you post your main large query that is taking the longest so I can give you tips on it?
__________________
MArms
self-help book | used cell phones | cell phone donation
Reply With Quote
Reply

  WebProWorld > Webmaster, IT and Security Discussion > Database Discussion Forum
Tags: mysql, optimising, queries


« Site Search Engine??? | Zip Code Locator »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


WebProWorld | Advertise | About | Forum Rules | MVP's | Archive | Newsletter Archive | Top | WebProNews | Statistics
WebProWorld is an iEntry, Inc. ® site - © 2008 All Rights Reserved Privacy Policy and Legal
iEntry, Inc. 2549 Richmond Rd. Lexington KY, 40509


All times are GMT -4. The time now is 02:21 AM.

Search Engine Friendly URLs by vBSEO 3.0.0