Re: Delete unused MySQL indexes Programming Databases by Dani Creating and removing database indexes is very complex and is not a matter of let's throw spaghetti at the wall and see what sticks. When working with big data, loads and loads of thought goes into each and every index. Nearly all indexes can work, but not as well as others might, and having too many indexes on a table can slow down inserts and … Integrating OpenAI Web Search API in LangGraph Programming Computer Science by usmanmalik57 Large language models are trained on a fixed corpus, and their knowledge is often limited by the documents they are trained on. Techniques like retrieval augmented generation, continuous pre-training, and fine-tuning enhance an LLM's default knowledge. However, these techniques can still not enable an LLM to answer queries that require web … Re: Justice Department Offers Grants Against Internet Predators Digital Media Digital Marketing by JackRyan248 > Despite a study earlier this year[/URL] that the fears of Internet predation against kids were overblown, the U.S. Department of Justice is $50 million through the American Recovery and Reinvestment Act of 2009, commonly known as the stimulus program, for Internet Crimes Against Children (ICAC) program initiatives. > > The programs … Re: How To Attract Client To Your Blog? Digital Media Digital Marketing by asadalig There are some ways to attract client your blog's which include: 1. Solve the problem of end-user. 2. The content should be like which speak directly to their needs, problem and goals. 3. The content must be consistent, authentic and user-friendly. Re: How to make an Iphone App? Programming Mobile Development by jonathannweyer One thing to keep in mind when planning an iOS app is the hardware and software constraints specific to Apple’s ecosystem, like limited background tasking or stricter App Store guidelines. Picking the right programming language, whether it's Swift or Objective-C, really depends on your team's experience and long-term plans. Also, if you're building… Re: Custom font on Cloudflare error page Programming Web Development by JackRyan248 > As you may know, yuo can customize the error pages in Cloudflare, such as for a WAF block, etc. > > For some reason, since the switchover to the new error pages dashboard, the custom font I always use isn't working. > > I can see that it converted https://cdn.daniweb.com/font.woff into inline base64 for the @font-face CSS, … Re: How to speed up my (WordPress) website? Digital Media Digital Marketing by Dani > In fact, my site is super fast (92% on mobile and 99% on desktop performance according to Google Page Speed). I see that this question has already been solved. However, I *do* feel inclined to ask: If you're saying your site is already super fast, why are you also saying you're struggling to make your site faster, it's driving you crazy, … Re: Fujitsu Windows Server 2019 Servers Rebooting at 11pm every day Hardware and Software Microsoft Windows by Reverend Jim Certainly the technology and tools have changed but principles of design and good programming styles have not. Python has, for the most part, replaced (effectively) dead languages like COBOL, and now-niche languages like FORTRAN, but structured programming and modular design are still essential techniques. I have seen too much code written by self-… Re: SEO vs AEO – Which is more important for the future of search? Digital Media Digital Marketing Search Engine Strategies by Dani It has to do with the type of website that is trying to gain traffic. However, for the most part, content sites are pretty frustrated that AI bots are scraping all of their content and then using it to directly answer a searcher's question, without the searcher ever having to visit the website. This is especially tough on content-based websites … Re: Java Coin Flip Program Programming Software Development by Salem > It looks like it's really helped a few people already. Yeah, 4 new members with consecutive user ID's, smelling like sock-puppet accounts. Re: Hi everyone, I'm David with SayItOnTheWeb Community Center Say Hello! by Dani I checked out your website and notice you're using the particles javascript at the bottom of the page. Many, many years ago, we used to use that as well, until we discovered it was causing some people's web browsers to crash, and for others, made the webpage unresponsive for users with slower computers. I would highly suggest that, instead, you … Re: Fujitsu Windows Server 2019 Servers Rebooting at 11pm every day Hardware and Software Microsoft Windows by Dani > >(where people abandoned us for sites like Stack Overflow) > > But there are still a few dinosaurs around who can answer some programming questions. Not to knock ya, but I think another part of the problem is that *all* that's left are dinosaurs who aren't necessarily skilled at the most trendiest things these days. There's … Re: Delete unused MySQL indexes Programming Databases by Dani As some general background, that's the syntax to delete an index, of course, but MySQL knows if an index is used because, well, it's the one that uses it, and it tracks that stuff internally. Now on to my question ... ;) Re: Coin Flip (Python Newbie) Programming Software Development by jassonadder Hey! Great job getting started with Python—your logic is almost there, just a couple of small fixes needed. The main issue is that you're using the variable timesflipped in your while loop, but it was never initialized. Because of that, the loop never runs properly, and your counters don't change. Here's a corrected version of your code:… Re: Help needed Related Website Digital Media Digital Marketing by ashishkumar56 > I need to rank my Website in USA for different services. I write article on digital marketing, SEO, SMM but i Cant get positive response. Some Expert Can help me If your articles on digital marketing, SEO, and SMM aren’t getting traction, focus on writing for specific user intent and not just keywords. Make sure your content answers real … Re: Java Coin Flip Program Programming Software Development by Dani Better late than never! Thanks for your post. It looks like it's really helped a few people already. Re: Java Coin Flip Program Programming Software Development by Dani > Yeah, 4 new members with consecutive user ID's, smelling like sock-puppet accounts. I realized that after I posted. I’m on my phone on the sofa so it wasn’t as easy to tell. Although I still can’t see the motivation. Edit: Nevermind. Perhaps they were trying to improve their member reputation/quality score?? (Won’t work because you need… Re: Is the Vision Pro worth it? Hardware and Software macOS by rproffitt One of my sons spent a lot setting up some other VR gear. And then broke his TV playing a game (punched the TV). 3 years later it sits in a box because it's out of date and new models that are worth buying are not worth buying (not going to rewrite that.) For me, not worth it. Re: Is the Vision Pro worth it? Hardware and Software macOS by Dani I find it vertigo-inducing to be sitting!! I simply cannot handle when what I see simulates me moving (e.g. walking in a room), but my physical body is not moving. It's fine if things are moving around me, but if *I'm* meant to be walking, I need to be physically walking in order to not get sick. Re: 💻 What’s the First App You Install on a Fresh Windows Machine? Hardware and Software Microsoft Windows by Reverend Jim I agree. [Everything](https://www.voidtools.com/) is always a definite install after imaging. It's something that should have been built into Windows. I've never found the need for any security software other than what comes with Windows. Re: Delete unused MySQL indexes Programming Databases by Dani OK, so I found [this blog post](https://www.percona.com/blog/basic-housekeeping-for-mysql-indexes/) by the one and only Percona, that says that I can simply do `select * from sys.schema_unused_indexes;` which does give me a list of indexes. However, it says it's based on having: update performance_schema.setup_consumers set enabled = 'yes' … Re: Cost-Effective Digital Marketing Ideas for New Startups? Digital Media Digital Marketing by Dani > Which digital marketing tactics gave you the most ROI early on? Purchasing backlinks, by far. But it was 2003 and Google didn't have a policy against doing it at the time. We live in a completely different world today. I wouldn't recommend it. > Are there any tools or platforms that worked especially well for lean teams? DaniWeb … Re: Delete unused MySQL indexes Programming Databases by Reverend Jim I thought it would be as simple as DROP INDEX index_name ON table_name; As for removing only unused indexes, I don't know how MySql would be able to determine if an index is used, or not. You'd have to decide. Since indexes are used to find things quickly I would imagine that if you delete an index and then take a performance hit it's … Re: Fujitsu Windows Server 2019 Servers Rebooting at 11pm every day Hardware and Software Microsoft Windows by Dani > But programming basics are still something people need help with, and the basics have not changed appreciably over my career. They sure have changed appreciably during *my* career! But maybe that's because my career is in web development, and the web, and the technologies that power the web, have changed *a lot* over the past 25 years. Heck… Re: How to speed up my (WordPress) website? Digital Media Digital Marketing by asadalig Website speed issues can be super frustrating. What really helped me was compressing images (I switched to WebP and used TinyPNG), setting up a caching plugin like WP Rocket, and minifying CSS and JS with Autoptimize. I also realized that bad hosting was slowing everything down, so I upgraded, and using a free CDN like Cloudflare made a noticeable… Re: Custom font on Cloudflare error page Programming Web Development by Dani Yes, it is. Cache settings are irrelevant? I was really just wondering if anyone else has experienced this issue, and what they did to fix it? Re: Are we being played by AI? Let's Discuss! Community Center Meta DaniWeb by Dani I agree that they *might* be AI generated, or at least have the help of AI. Sometimes it's hard to tell, and I always want to exercise extreme caution and not delete or infract a post unless I'm 100% confident. I have a bit of a migraine right now, so I have to put a little more thought into whether these 2 posts should be deleted when my head is a… Re: Are we being played by AI? Let's Discuss! Community Center Meta DaniWeb by Reverend Jim And I disagree with that. The post I was referring to was >In this thread, let's dive into the exciting advancements in the world of audio technology. From spatial audio to AI-driven sound systems, the audio landscape is evolving rapidly. Share your thoughts on the latest innovations, your favorite audio gadgets, or how new tech is shaping … Re: Are we being played by AI? Let's Discuss! Community Center Meta DaniWeb by Reverend Jim I have a problem with people who start posts about a topic with "let's discuss", but don't actually start the discussion. I have a friend (?) in Toronto who, especially during election season (which seems to be always these days), asking for my opinion on things without ever offering one of her own. I got tired of putting in the effort … Re: Are we being played by AI? Let's Discuss! Community Center Meta DaniWeb by Reverend Jim 1. I thought we didn't have "forums" anymore. 2. Perhaps the OP posted in the wrong place. 3. Regardless, it was clearly a discussion and not a question. It's moot since the thread has been deleted.