Click here to Skip to main content
15,906,626 members
Home / Discussions / Web Development
   

Web Development

 
QuestionAccess mobile sms on pc in c# Pin
Member 912444117-Nov-16 23:25
Member 912444117-Nov-16 23:25 
AnswerRe: Access mobile sms on pc in c# Pin
Afzaal Ahmad Zeeshan20-Nov-16 23:06
professionalAfzaal Ahmad Zeeshan20-Nov-16 23:06 
QuestionHOW TO CODE CPK Chart in vb.asp.net Pin
BHARAT NAVINCHANDRA PATEL11-Nov-16 20:01
BHARAT NAVINCHANDRA PATEL11-Nov-16 20:01 
AnswerRe: HOW TO CODE CPK Chart in vb.asp.net Pin
ZurdoDev16-Nov-16 1:08
professionalZurdoDev16-Nov-16 1:08 
QuestionHow to trigger on change on a HTML5 var tag? Pin
Nicky Tse11-Nov-16 2:26
Nicky Tse11-Nov-16 2:26 
AnswerRe: How to trigger on change on a HTML5 var tag? Pin
Richard Deeming11-Nov-16 3:20
mveRichard Deeming11-Nov-16 3:20 
GeneralRe: How to trigger on change on a HTML5 var tag? Pin
Nicky Tse11-Nov-16 3:31
Nicky Tse11-Nov-16 3:31 
GeneralRe: How to trigger on change on a HTML5 var tag? Pin
Richard Deeming11-Nov-16 3:39
mveRichard Deeming11-Nov-16 3:39 
QuestionHow to parse the excel sheet using javascript and do the rest service Pin
Member 128302459-Nov-16 2:16
Member 128302459-Nov-16 2:16 
AnswerRe: How to parse the excel sheet using javascript and do the rest service Pin
Richard MacCutchan9-Nov-16 2:25
mveRichard MacCutchan9-Nov-16 2:25 
QuestionAngular 2 Grid Pin
Member 127933317-Nov-16 21:58
Member 127933317-Nov-16 21:58 
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 

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.