Jump to content
Latest News: (loading..)

Search the Community

Showing results for tags 'optimization'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • News and Announcements
    • News and Announcements
    • Partner Announcements
    • Ambassadors
  • Commercial Support
    • Developer Feedback
  • osCommerce Online Merchant v2.x
    • General Support
    • Installation and Configuration
    • Upgrading from Earlier Versions (v2.x to v2.x)
    • Add-Ons
    • Tips and Tricks
    • Security
  • Development
    • osCommerce Online Merchant v2.4
    • osCommerce Online Merchant Community Bootstrap Edition
    • osCommerce Online Merchant v3.x
    • Development Proposals
  • General
    • OSCOMMERCE.TV
    • Next Steps / Optimizations / Marketing
    • Live Shop Reviews
    • E-Commerce Laws
    • General Discussions
    • PHP / SQL / Web Design
  • oscBooks and oscTemplates's Announcements
  • PayPal's Announcements
  • Sage Pay's Announcements
  • Solomono - new level osCommerce templates's Announcements
  • German Community's OSCOM v2.x
  • German Community's Allgemein
  • German Community's OSCOM v3.x

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Real Name


Location


Interests


Website


Skype

Found 3 results

  1. This is the support thread for .htaccess Optimisation. Installation: Upload the .htaccess file, or if you already have one, copy the text and add it to your .htaccess file. What does it do? This add-on will optimise your site, massively speeding it up, reducing your bandwidth usage and possibly increase your search engine ranking. How? In two ways, first, by compressing files that can be sent compressed, sometimes reducing file transfer size by upto 80%. Second, by controlling the cache, thus again reducing server load. Link: http://addons.oscommerce.com/info/8927
  2. katapofatico

    LIMIT 1 optimization

    I'm migrating to osc 2.3.x from a old osc version. I'm surprised because I see again SQL SELECT queries without "LIMIT 1" optimizations. An example, on application_top.php: for ($i=0, $n=sizeof($cPath_array); $i<$n; $i++) { $categories_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$cPath_array[$i] . "' and language_id = '" . (int)$languages_id . "'"); // possible LIMIT 1 optimization if (tep_db_num_rows($categories_query) > 0) { $categories = tep_db_fetch_array($categories_query); [...] } ...few lines more and again: if (isset($HTTP_GET_VARS['products_id'])) { $model_query = tep_db_query("select products_model from " . TABLE_PRODUCTS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); // possible LIMIT 1 optimization if (tep_db_num_rows($model_query)) { $model = tep_db_fetch_array($model_query); [...] } } Do you imagine how much the performance is downgraded? It's a basic best practice developing: don't you plan implement it? Thanks in advance
  3. On table zones, the zone_id field is defined as PRIMARY AUTOINCREMENT, therefore I think that the field zone_country_id is unnecessary on these functions on general.php (on both admin/ and root directories): function tep_get_zone_name($country_id, $zone_id, $default_zone) { $zone_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country_id . "' and zone_id = '" . (int)$zone_id . "'"); [...] } function tep_get_zone_code($country_id, $zone_id, $default_zone) { $zone_query = tep_db_query("select zone_code from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country_id . "' and zone_id = '" . (int)$zone_id . "'"); [...] }
×