Click here to Skip to main content

Welcome to the Lounge

   

For lazing about and discussing anything in a software developer's life that takes your fancy.
The Lounge is rated PG. If you're about to post something you wouldn't want your kid sister to read then don't post it. No flame wars, no abusive conduct and please don't post ads.

Technical discussions are welcome, but if you need specific help please use the programming forums.


 
GeneralRe: Anyone Here? PinprofessionalRavi Bhavnani18-Aug-13 17:41 
GeneralRe: Anyone Here? Pinprofessionalvonb18-Aug-13 19:25 
JokeRe: Anyone Here? PinmemberAnthony DiNozzo18-Aug-13 19:57 
GeneralRe: Anyone Here? Pinprofessionalvonb18-Aug-13 20:06 
JokeRe: Anyone Here? Pinmemberenhzflep18-Aug-13 21:11 
GeneralRe: Anyone Here? PinmemberRedDk19-Aug-13 8:40 
GeneralRe: Anyone Here? [modified] PinmemberRedDk19-Aug-13 9:20 
GeneralStarting from scratch PinmemberDalek Dave18-Aug-13 7:27 
I have been moaning about the performance speeds and loading times for my website and nothing I seemed to do hrlped.
 
It seemed that the bug in the opencart software was the nucleus of all my trobles.
 
It insisted on doing a category count every time you clicked on a link and with nearly 30, 000 items in hundreds of categories this was destroying the available resources.
I migrated from a shared to a dedicated server which brought more issues into equation as it was now not pointing to the right server.
I enacted a very kludgy repair but it didnt help much, although I could now see the database.
Then there was problems with the admin panel, and again a quick and nasty patchbto the config.php file resolved it.
 
I then found out about the bug and did an upgrade to the software thinking this would fix the problem, but it did not help.
 
A corrupted db on badly patched software with server pointing issues and a partial upgrade had all taken their toll.
 
I decided that it would be better to wipe it out and start from scratch..
 
So, bravely, I killed the lot.
 
Downloaded and installed the opencart software (latest version with the fix), intalled vqmod, then created a new MySQL DB a:nd attached that to the store. Added the various extras I had purchased and uploaded the csv file.
 
Hey presto...
 
Page loading in 2 seconds, not two minutes.
 
It was brave of me though, I habe used plesk before and my db skills are very rusty.
 
All in all though I am pleased with the result.
---------------------------------
Obscurum per obscurius.
Ad astra per alas porci.
Quidquid latine dictum sit, altum videtur.
 


GeneralRe: Starting from scratch PinprotectorOriginalGriff18-Aug-13 7:45 
GeneralRe: Starting from scratch PinmemberDalek Dave18-Aug-13 7:58 
GeneralRe: Starting from scratch PinprofessionalManfred R. Bihy18-Aug-13 8:15 
GeneralRe: Starting from scratch PinmemberDalek Dave18-Aug-13 8:38 
GeneralRe: Starting from scratch Pinmembergrralph118-Aug-13 23:49 
GeneralMy Oldest Communities PinprofessionalBassam Abdul-Baki18-Aug-13 6:20 
GeneralRe: My Oldest Communities PinmemberForogar18-Aug-13 6:25 
GeneralRe: My Oldest Communities PinprofessionalMycroft Holmes18-Aug-13 11:57 
GeneralRe: My Oldest Communities PinmemberBrady Kelly18-Aug-13 21:28 
GeneralRe: My Oldest Communities PinmemberForogar19-Aug-13 4:08 
GeneralRe: My Oldest Communities PinprofessionalRajesh R Subramanian18-Aug-13 6:52 
GeneralRe: My Oldest Communities PinmvpAbhinav S18-Aug-13 7:17 
GeneralRe: My Oldest Communities PinprofessionalBassam Abdul-Baki18-Aug-13 7:20 
GeneralRe: My Oldest Communities PinmvpAbhinav S18-Aug-13 7:40 
GeneralRe: My Oldest Communities PinprotectorOriginalGriff18-Aug-13 7:22 
GeneralRe: My Oldest Communities PinmemberForogar19-Aug-13 4:11 
GeneralRe: My Oldest Communities PinmemberChrisElston18-Aug-13 8:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.140916.1 | Last Updated 17 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid