Re: Is graphic design useful for UI UX? Digital Media UI / UX Design by Dani I would argue that data analytics is more important. Is graphic design useful for UI UX? Digital Media UI / UX Design by Ali_96 Having a degree in graphic design can be beneficial when pursuing a career in UX/UI design since the two fields have many overlapping skills. Re: how to create a simple elevator simulation? Programming Software Development by trueframe To make a basic elevator simulation, first, identify the floors and the elevator's capacity. Then, use loops and conditionals in programming to mimic its movement. Include buttons for users to call the elevator and select floors. Test thoroughly for accuracy. Re: Improve HAVING BY performance Programming Databases by toneewa …start_time2 = std::chrono::high_resolution_clock::now(); // Third query with HAVING stmt->execute("SELECT ProductName, AVG(Price) AS AvgPrice…electronics.Products " "GROUP BY ProductName " "HAVING AVG(Price) > 4.00"); sql::ResultSet* result2 … Re: Improve HAVING BY performance Programming Databases by Biiim …! That said, I mean't that the HAVING statement is like dumping your query result into… this question, I was working on a HAVING clause that was filtering recommended topics by a…in the SELECT clause, hence the need for HAVING. I switched to using JOINS, and then …up by moving the or's into the HAVING usually. Subqueries is similar depending on the… Re: Improve HAVING BY performance Programming Databases by Dani …gt; SELECT sum(points) total FROM ... HAVING points > 10 I don't have…I do `SELECT sum(points) AS total FROM ... HAVING total > 10`. Is that what you were…provoked this question, I was working on a HAVING clause that was filtering recommended topics by a …in the SELECT clause, hence the need for HAVING. I switched to using JOINS, and then was… Re: Improve HAVING BY performance Programming Databases by toneewa …Query execution time: 0.0599129 seconds HAVING Query execution time: 0.0621748 seconds HAVING Query execution time: 0.0629348 seconds…Query execution time: 0.0002878 seconds HAVING Query execution time: 0.0002313 seconds HAVING Query execution time: 0.0002674 seconds … Re: Improve HAVING BY performance Programming Databases by Biiim … solved, but I wanted to make it known that the HAVING clause runs on the returned result set of your query… from a column name, like `SELECT sum(points) total FROM ... HAVING points > 10` (will error cause points doesn't exist… in the temp result set, only total I only use HAVING for botch jobs when you just want some complicated data… Re: Improve HAVING BY performance Programming Databases by toneewa …49.43 49.39 49.98 49.22 49.57 HAVING Query execution time: 0.245288 seconds Diode 24.1361 …1737 Transistor 24.0247 Resistor 24.1304 Inductor 24.1018 HAVING Query execution time: 0.436416 seconds Diode 24.1361 … Re: Improve HAVING BY performance Programming Databases by Dani … sites as large as DaniWeb, it's an uphill battle having enough crawl budget to entice Google to crawl deeper and… Re: Improve HAVING BY performance Programming Databases by Dani … speed it up by moving the or's into the HAVING usually. Thank you for that tip! I never thought of… Re: Improve HAVING BY performance Programming Databases by Dani … not comparing apples to apples. Your WHERE query and your HAVING query perform different calculations and do different things. In one… Re: Improve HAVING BY performance Programming Databases by Dani … data, there’s no way of saying whether where or having is faster. You would need to write queries that use… Re: Improve HAVING BY performance Programming Databases by toneewa …++: 0.018953 sec MWB: 0.000 sec / 0.000 sec HAVING: C++: 0.0626546 sec MWB: 0.062 sec / 0.000… Re: This is me venting Community Center Meta DaniWeb by Dani … / forum / interviews I have always been a strong proponent of having editorial (news, tutorials, interviews, etc.) complement the user-generated forum…, our Google rankings tanked a lot due to no longer having regular news stories and editorial daily. However, I'm still… Re: How can I upload a tar.bz2 file to openstack swift object storage container Programming Software Development by Hanginium65 … sent and I got the error regarding the 'NoneType' object having no attribute 'read'. Please see below the attempt I made… Re: How can I upload a tar.bz2 file to openstack swift object storage container Programming Software Development by Salem I don't understand why you need to extract all the files from the compressed `tar.bz2` just to upload to a backup. Also, line 69 is now meaningless having just posted only a snippet of the code. Before the error, what was the last `logger.info` message? This is me venting Community Center Meta DaniWeb by Dani … targeted attack at *anyone*. Please take it just as me having a bad day and venting. I'm kinda tired of… Question Answering with YouTube Videos Using RAG in LangChain Programming Computer Science by usmanmalik57 … (Arc de Triomphe) for a view of the city. 2. Having a picnic near the Eiffel Tower with food from a… Re: ASUS Laptops - my experience Hardware and Software by Reverend Jim … in 60 seconds Thinking that the Logitech site might be having a problem (everything else on the site seemed normal) I… is supposed to work. Imagine buying house insurance and then having a fire that destroys your house. No problem because the… everything manually. With luck (I don't seem to be having a lot of this lately) I won't have to… Re: ASUS Laptops - my experience Hardware and Software by Reverend Jim …. I wish I'd checked it further because I started having problems as soon as I got it home and powered… is my last day of warranty and Best Buy is having another go at it. If they can't fix it… Re: ASUS Laptops - my experience Hardware and Software by toneewa I wouldn't worry about not having any ASUS utilities. You can always download them later, [here](….asus.com/support/download-center/). I consider them all bloatware. Having the partition as an MBR and then installing a Windows… Re: And so the cookie crumbles... Community Center Geeks' Lounge by Dani … post](https://www.daniweb.com/programming/databases/threads/541622/improve-having-by-performance#post2296496) it seems you feel as if DaniWeb… Re: Do you participate in any other communities? Community Center Geeks' Lounge by Dani … was super excited when he bought them because I love having friends also in the forum business who I can talk… Re: ASUS Laptops - my experience Hardware and Software by toneewa … bag. I've seen in the past failures due to having more than 1 drive installed. Disconnect all other drives and… Re: DaniWeb Auto Answer A.I. feature Community Center Meta DaniWeb by toneewa … a thought, but not limited there. There's creative solutions. Having only users with an RTX card can use the feature… Re: sequential file save read option button Programming Software Development by rproffitt 1. With so few having VB6 now, you need to move to a current release. … Re: Improve HAVING BY performance Programming Databases by Reverend Jim Was it worth all that for 50ms? Re: Improve HAVING BY performance Programming Databases by Dani In exchange for less than a day's worth of work? Of course!!!!! I've spent a *lot* longer to shave off a *lot* less. https://www.conductor.com/academy/page-speed-resources/faq/amazon-page-speed-study/ Re: Improve HAVING BY performance Programming Databases by Dani Now as far as whether going down that rabbit hole that day was worth the cost of losing AndreRet, then I'd have to give a resounding no.