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 I'm a little late to the party, however, I want to share my experience learning MySQL in the past day. I setup a server, a database, and wrote a C++ program to connect to it. It measures the times for 3 SELECTs. The whole product list, using HAVING, and WHERE. I also tested reversing the orders. Query execution time: 0.0002336 seconds … 'Prepare for the Earliest Possible AGI Deployment Scenario' Community Center by Johannes C. **Despite the uncertain timeline for Artificial General Intelligence (AGI) becoming a reality, we need to assure responsible and ethical development today – says Jen Rosiere Reynolds.** ![header-agi-talks1.png](https://static.daniweb.com/attachments/4/5595ff2ec36fde155011d21ea73dcd78.png) As part of our new **AGI Talks**, experts from … Re: Improve HAVING BY performance Programming Databases by Biiim > INSERT INTO electronics.products(ProductID, ProductName, Price) VALUES ('1','capacitors', 2.50), ('2','resistors', 4.50), ('3','rectifiers', 7.50), ('4','diodes', 10.00), ('5','ICs', 25.00), ... ('50000','...', ...); I don't see any mention of an index on it & your benchmark indicates you don't have one: ALTER TABLE `… Re: Read file properties of video files in C++ Programming Software Development by toneewa The [Windows Media Foundation API](https://learn.microsoft.com/en-us/windows/win32/api/mfmediaengine/nf-mfmediaengine-imfmediaengine-getduration#requirements) is probably what you are thinking of. You also can just use my example, using the ffmpeg library. Just change the filename. extern "C" { #include <libavformat/… Re: ASUS Laptops - my experience Hardware and Software by rproffitt "I allocated a C partition and formatted as NTFS then boot back into my Windows 11 install USB." That can derail the usual Windows install. On today's PCs I start off with a blank, no partition drive, boot the Windows USB stick and once in a while need to add the Intel RST storage driver. I maintain that Microsoft should update … Re: Which social sites is best for SEO? Digital Media Digital Marketing by Bunker The social sites best for SEO typically include platforms with high domain authority and user engagement, such as Facebook, Twitter, LinkedIn, and YouTube. These platforms allow for content sharing, backlinking, and visibility, positively impacting search engine rankings when used strategically with relevant keywords and quality content. Re: What are the key components of an effective email marketing campaign? Digital Media Digital Marketing by trueframe Key components include compelling subject lines, personalized content, clear call-to-action, mobile optimization, segmentation, analytics tracking, and consistent engagement with subscribers. Re: Things I hate about TV shows Community Center Geeks' Lounge by Dani Currently the thing I hate most about TV shows is how much time elapses between seasons. I feel like I've been waiting for season 2 of Severance on AppleTV for *forever*! (It's been over 2 years already since season 1 debuted.) Speaking of that, is there ever going to be a second season for Squid Game? I can't imagine that Netflix wouldn’t invest … Re: Things I hate about TV shows Community Center Geeks' Lounge by Reverend Jim Fer sher. You pretty much have to watch the previous season again before you start the next one. I'm still waiting for season 2 of The Old Man (Jeff Bridges, John Lithgow). At my age sometimes I lose the thread if two weeks goes by between episodes. Sometimes I'll wait until the end of a season before I watch any of it. I especially hate it when a … Re: What is best method for link building nowadays? Digital Media Digital Marketing Search Engine Strategies by KomalBhatt Yes. always focus on quality and not on quantity. creating a link is important but always follow the algorithm. Do organic SEO. Or else it will considered in black hat seo. You can focus on doing blog submissions, Question and answers for getting a backlink, always remember to check DA and PA of the website Re: Things I hate about TV shows Community Center Geeks' Lounge by pritaeas > is there ever going to be a second season for Squid Game Yes, already announced, available soon. Re: Things I hate about TV shows Community Center Geeks' Lounge by Dani That's my point, though. Gone are the days when a show would break for a summer and the next season would start up again in the fall. Re: Things I hate about TV shows Community Center Geeks' Lounge by Reverend Jim >Gone are the days That's pretty much the case for everything. I remember when TV sucked all through summer vacation and I couldn't wait for the end of September for the new seasons to start. Of course it was bittersweet because September also meant back to school. I'll mention a few more things that may have been mentioned before but I … Re: Things I hate about TV shows Community Center Geeks' Lounge by KomalBhatt You know, there are few things more frustrating than getting interested in a TV show only to find it falling short of expectations. From the overly predictable plotlines to the underdeveloped characters, there's a huge list. But what really get irritated by is when the dialogue feels forced, like the writers are trying too hard to be clever or … Re: What is best method for link building nowadays? Digital Media Digital Marketing Search Engine Strategies by webhostingworld One effective approach is to create valuable and informative content that others will want to link to, such as blog posts, infographics, or videos. By consistently producing top-notch content, you can attract organic backlinks. Re: Improve HAVING BY performance Programming Databases by Biiim I realise this has been marked as solved, but I wanted to make it known that the HAVING clause runs on the returned result set of your query, which as you say has no indexes on it as it is just a temporarily created result set - but has the benefit of allowing you do do some simple post-processing on the result set. (This is for MariaDB at least)… Re: Improve HAVING BY performance Programming Databases by Dani > SELECT sum(points) total FROM ... HAVING points > 10 I don't have experience with MariaDB, but in MySQL, something like that will work as long as I do `SELECT sum(points) AS total FROM ... HAVING total > 10`. Is that what you were getting at? As far as what I was trying to accomplish that provoked this question, I was working on a … 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. Re: Improve HAVING BY performance Programming Databases by Reverend Jim I have to admit that 95% of my work from 1995 to 2008 was back end stuff where I didn't have to worry about stuff like that. Digital plumbing and monitoring. The other 5% was single user apps. Not counting the 20% which was pointless meetings. So if you don't mind explaining, I'm curious as to why 50ms would even be noticible. I'm not asking just … Re: Improve HAVING BY performance Programming Databases by Dani I'm too exhausted for an in depth explanation right now but 90% of web development is optimizing for performance. The average DaniWeb page takes anywhere from 80ms up to 250ms to load the HTML (when dealing with low network latency), depending on the type of page, so shaving 50ms off of that is a huge win. Re: Improve HAVING BY performance Programming Databases by Dani Here are some articles that can explain it in greater depth: * https://web.dev/learn/performance/why-speed-matters * https://developer.mozilla.org/en-US/docs/Learn/Performance * https://web.dev/explore/fast The HTML page must be downloaded in its entirety before the web browser can begin loading anything else (CSS, Javascript, images, etc.)… Re: Improve HAVING BY performance Programming Databases by Reverend Jim I suppose I am looking at it in terms of practicality. I suppose there might be several reasons to optimize: 1. It saves resources on the hosting platform 2. It improves the user experience 3. It provides personl satisfaction Point #1 would save you money if the savings were significant. Point #2 would apply if the improvement was … Re: Improve HAVING BY performance Programming Databases by Biiim > I don't have experience with MariaDB, but in MySQL, something like that will work as long as I do SELECT sum(points) AS total FROM ... HAVING total > 10. Is that what you were getting at? Kind of, MariaDB is a fork of MySQL from around 2009 or something like that, MySQL 5.* and the creator continued developing MariaDB and Oracle took … Re: What is best method for link building nowadays? Digital Media Digital Marketing Search Engine Strategies by aishamushtaq You've nailed it! Effective link building involves high-quality content, guest blogging, broken link opportunities, social media promotion, and influencer collaboration. Quality beats quantity, and staying updated on search engine algorithm changes is essential. Re: Improve HAVING BY performance Programming Databases by Dani > Point #2 would apply if the improvement was noticible but I doubt anyone could seriously comment, "I think this page rendered 50ms faster than it used to", especially considering all the other things that affect timing, for example, the current loading on my ISP servers, anything else running on my computer or home network, etc. … Re: Improve HAVING BY performance Programming Databases by Dani > I know that in my experience, OR's are very bad for speed you can get away with a few but they can get very bad when they stop the whole query making use of one of the main indexes, you can actually speed it up by moving the or's into the HAVING usually. Thank you for that tip! I never thought of that, but it totally makes sense!! > … Re: AirTM API: How to Build a Form? Programming Web Development by pritaeas https://docs.airtm.com/purchases-payins/create-purchase You can choose PHP in the dropdown above the sample code. That way you can see what your PHP should contain.