Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by cliffconway

  1. When I cleared out I tried steps 1 to 3. Still slow. I have set up indexes as suggested. Still slow order query. Given that there are now only 2 logs in the table (and originally only 3500 records) I am sure that the delay is not, in any major way, related to the ps_logs table. I have taken the orders generated SQL statement related to the orders query and run it in phpMyAdmin and MySQL workbench. Removing the "SQL_NO_CACHE" improves the times dramatically (after the first run which obviously builds the cache). So this clause seems to be the root of the issue. Thanks again
  2. Thanks EvaF for your fast response. The ps_logs had 3,500 records only. I cleared them out and still long delays on the order query. I will try indexing as recommended
  3. I am experiencing long delays in the BO Orders function (300,000 + orders). Switching on Debug I notice that the SQL statement generated by the php AdminController includes the "SQL_NO_CACHE" clause. I am aware that the database access statement in the controller ($db->executeS($sql, true, false);) has a parameter related to caching (currently set to false). I am aware that removing the no cache clause may have other ramifications. However, I have set the cache parameter (in the relevant executeS code in the controller statement) to true and still the order SQL queries have the "SQL_NO_CACHE" clause inserted. Why does this caching parameter appear not to work? If I am on the wrong track, related to delays, then any other useful info that can help me remove the "SQL_NO_CACHE" for my experimentation would be very much appreciated. Thanks in advance
  4. I have just started working with PrestaShop and I am intending to support a 3rd party developed theme. I was wondering if any members have thoughts on which IDE's I should consider as prime candidates to work with for PHP? Thanks in advance,
  5. Thanks ndiaga for your comments. As you will notice I specifically asked about any books or tutorials related to PHP and not PrestaShop. As you say and, as anyone observant would have noticed, there are many tutorials out there about PHP - it would be difficult to miss them! My plea was to seek help to narrow the field down rather than generalise. Any thoughts? Thanks again.
  6. I am a professional developer who is new to PrestaShop and PHP. Would anyone like to recommend any books or tutorials related to PHP that would help with my learning curve related to PrestaShop (MVC and OO principles used. I have been asked to take on some maintenance work (bug fixings) related to a Theme). Any ideas will be most appreciated.
  7. Hi, I am using PS and I have a problem with using Web Services. I have set up a web service access key that gives access to certain tables. If I try to access these tables using the web service I can successfully access tables that have a small number of records (say 8) but not tables that have a larger number of records(tens of thousands). I suspect this maybe by design to prevent performance issues? Is there a way to resolve this issue? Thanks in advance,
  8. So almost one week and no responses. Does this mean that PrestaShop doesn't have an active developer user base? Not sure what to tell my client about this Makes me unsure about PrestaShop as a recommendation.
  9. Hi, I am working with a client who is planning a move from a competitor's product (JShop) to PrestaShop.The client is intending to maintain his current catalogue process which involves using a spreadsheet which is then mass imported into JShop. He believes this offline process provides him with more flexibility with catalogue creation and maintenance. Of course, the success of this assumes he could reflect the JShop product table related updates on PrestaShop automatically (probably through triggers). Yeah I know this sounds bizarre. However, my client insists that he has looked at what would be involved in creating and maintaining his product catalogues on PrestaShop and he is adamant that he needs to maintain his current processes using spreadsheet and Jshop mass update - somehow!! Obviously, the table structures on JShop and PrestaShop are not similar. One possible approach could be to set up triggers on the JShop database that update the product tables on PrestaShop when inserts, updates or deletes occur on JShop. Now the big question. To make sure that the necessary updates take place on the PrestaShop database one would need to know the table updates that occur within PrestaShop when a normal creation of a product takes place using the PrestaShop functionality. Now I appreciate that a number of ancillary tables will need to exist before a new product is triggered/created through PrestsShop (i.e. ps_shop, ps_tax etc...). So the question is, is there any documentation that gives details of the database table updates related to creating a product on PrestaShop? Any suggestions will be much appreciated. Thanks in advance, Cliff
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More