Mar 13
Alex Betz Best practice/ speediest way do deal with frequently recurring DB requests
Mar 13, 2015; 09:50
Alex Betz
Best practice/ speediest way do deal with frequently recurring DB requests
Hi list,
I have a very general, strategic question, regarding best practice (L9 - if
versions influence the answer).
On my website I have several 'dynamic menus' which I generate for each
page. The items in the menus can change at any time, but really do so maybe
twice a day, if at all. I currently build the menus using a mysql queries,
every time the page is build. For some pages, I build up to 5 submenus this
way. It as pretty fast as my page load times are reasonable mostly <2sec
under average load. However, I suspect as page loads increase things do
slow down considerably.
While this is a very convenient, low maintenance way to do it, I am sure
there are better ways.
1) thread objects
2) custom types with data preloaded onCreate
3) mem cached
4) lasso caching
5) building static pages from the admin side which causes changes
Which of these is the best/fastest way to do things? Are there other even
better strategies?
I'd suspect that each of these menus could be stored as a string of 0.5-5kb
size. I have some about three menus which are literally called on every
page. And another 100 which are build for specific pages. In extreme, the
same problem actually applies for the whole product catalog, but here mysql
is likely to be the best option anyway.
I am looking forward to a vivid discussion, as I assume this will be
applicable to many users.
Cheers
Alex
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Mar 13
Jolle Carlestam Re: Best practice/ speediest way do deal with frequently recurring DB requests
Mar 13, 2015; 11:28
Jolle Carlestam
Re: Best practice/ speediest way do deal with frequently recurring DB requests
Mar 13
Steve Piercy - Website Builder Re: Best practice/ speediest way do deal with frequently recurring DB requests
Mar 13, 2015; 04:43
Steve Piercy - Website Builder
Re: Best practice/ speediest way do deal with frequently recurring DB requests
Mar 13
Alex Betz Re: Best practice/ speediest way do deal with frequently recurring DB requests
Mar 13, 2015; 14:03
Alex Betz
Re: Best practice/ speediest way do deal with frequently recurring DB requests
Mar 13
Carl Ketterling Re: Best practice/ speediest way do deal with frequently recurring DB requests
Mar 13, 2015; 09:12
Carl Ketterling
Re: Best practice/ speediest way do deal with frequently recurring DB requests
Mar 13
Steve Piercy - Website Builder Re: Best practice/ speediest way do deal with frequently recurring DB requests
Mar 13, 2015; 12:28
Steve Piercy - Website Builder
Re: Best practice/ speediest way do deal with frequently recurring DB requests
Mar 13
Jason Huck Re: Best practice/ speediest way do deal with frequently recurring DB requests
Mar 13, 2015; 15:29
Jason Huck
Re: Best practice/ speediest way do deal with frequently recurring DB requests