Click here to Skip to main content
15,887,585 members
Home / Discussions / Web Development
   

Web Development

 
AnswerRe: Angular 2 Grid Pin
Anurag Gandhi13-Nov-16 6:00
professionalAnurag Gandhi13-Nov-16 6:00 
Questionproblem to proj(html.css) Pin
Member 128357006-Nov-16 10:40
Member 128357006-Nov-16 10:40 
AnswerRe: problem to proj(html.css) Pin
Anurag Gandhi13-Nov-16 6:01
professionalAnurag Gandhi13-Nov-16 6:01 
Questionhtml print on separate pages of pdf or word document Pin
dcof2-Nov-16 8:28
dcof2-Nov-16 8:28 
Questionhow to integrate razor with angular 2 ngModel ? Pin
Ay Sy30-Oct-16 5:16
Ay Sy30-Oct-16 5:16 
AnswerRe: how to integrate razor with angular 2 ngModel ? Pin
Anurag Gandhi13-Nov-16 6:05
professionalAnurag Gandhi13-Nov-16 6:05 
QuestionWebservice - beginner questions Pin
TrytoFly230-Oct-16 2:23
TrytoFly230-Oct-16 2:23 
QuestionWhats the best practice to get multiple filter layers with same sub-query? Pin
Member 1281896427-Oct-16 0:39
Member 1281896427-Oct-16 0:39 
Hello everyone,

I have a little problem while coding an e-commerce site, built on symfony3.

Here is an overview of my used table on mysql-side: [^]

As shown here, there is only one table where i am selecting the data from. No annoying joins between multiple tables which may slow down speed.

Here is a little mockup to show the actual status quo of what i want to render: [^]

The Usecase is to get a filtered product view (for example "give me all products where color is green"). Then you get all products listet (red area) + on sidebar the possibility to set further filters for filtering stuff like the brand or size (yellow area; in practical there are even some more filter to use).

The Problem now is, as you see, each result i have to use another adjusted query (for the sidebar different "GROUP BY" statements) with always the same subquery which represents the actual selected productcollection.

This is slowing down my site extremely heavy (as there are over 1 million products in the database as i need about 7-8 times the same query with a little bit different parameters every time).

I found the solution that it would be better to switch to MariaDB, so it would be possible to cache all the subqueries. That is not possible on the actual environment i am working on. MySQL caching is activated here.

Does anyone can give me some hints what i can do to minimize the the queries or mainly speed up the whole process when generating the data for the view? Is there any better solution as I do actually? I guess so..

Many thanks in advance for your help and ideas!
SuggestionRe: Whats the best practice to get multiple filter layers with same sub-query? Pin
Richard Deeming27-Oct-16 2:28
mveRichard Deeming27-Oct-16 2:28 
Questionhtml - use in search and replace - possibly with invisible html Pin
dcof26-Oct-16 12:54
dcof26-Oct-16 12:54 
AnswerRe: html - use in search and replace - possibly with invisible html Pin
Peter_in_278026-Oct-16 15:11
professionalPeter_in_278026-Oct-16 15:11 
GeneralRe: html - use in search and replace - possibly with invisible html Pin
dcof27-Oct-16 5:13
dcof27-Oct-16 5:13 
GeneralRe: html - use in search and replace - possibly with invisible html Pin
Peter_in_278027-Oct-16 12:09
professionalPeter_in_278027-Oct-16 12:09 
QuestionRegarding Positioning Using DIV Pin
JeremiasR25-Oct-16 5:46
JeremiasR25-Oct-16 5:46 
QuestionDropdown menu unable to be displayed Pin
dell-gl62m20-Oct-16 17:45
dell-gl62m20-Oct-16 17:45 
AnswerRe: Dropdown menu unable to be displayed Pin
ZurdoDev25-Oct-16 2:07
professionalZurdoDev25-Oct-16 2:07 
AnswerRe: Dropdown menu unable to be displayed Pin
dell-gl62m31-Oct-16 16:44
dell-gl62m31-Oct-16 16:44 
Questionfor developing website, is it essential to divide the area into some portion in defining frame set. Pin
Member 1279387014-Oct-16 5:43
Member 1279387014-Oct-16 5:43 
AnswerRe: for developing website, is it essential to divide the area into some portion in defining frame set. Pin
ZurdoDev14-Oct-16 6:01
professionalZurdoDev14-Oct-16 6:01 
AnswerRe: for developing website, is it essential to divide the area into some portion in defining frame set. Pin
Richard Deeming14-Oct-16 6:07
mveRichard Deeming14-Oct-16 6:07 
AnswerRe: for developing website, is it essential to divide the area into some portion in defining frame set. Pin
David Mujica17-Oct-16 7:25
David Mujica17-Oct-16 7:25 
QuestionWhich java Concepts are important for Learning Android Pin
Member 122291026-Oct-16 11:12
Member 122291026-Oct-16 11:12 
AnswerRe: Which java Concepts are important for Learning Android Pin
Richard MacCutchan6-Oct-16 23:47
mveRichard MacCutchan6-Oct-16 23:47 
AnswerRe: Which java Concepts are important for Learning Android Pin
ZurdoDev14-Oct-16 6:02
professionalZurdoDev14-Oct-16 6:02 
AnswerRe: Which java Concepts are important for Learning Android Pin
Member 1222910214-Oct-16 8:19
Member 1222910214-Oct-16 8:19 

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

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