7 NLP Tasks to Perform for Free in Python with Mistral 7b LLM Programming Computer Science by usmanmalik57 … field of Natural Language Processing (NLP), open-source large language models (LLMs) are becoming increasingly popular as… API incurs charges. This is where open-source Large Language Models (LLMs) like Mistral 7b become game…input paragraph. ``` paragraph = """ A large language model (LLM) is a language model notable for … Re: Improve HAVING BY performance Programming Databases by Dani Yes, that's true. But for those instances where we are left in circumstances where we have to perform HAVING on large tables, is there *anything* we can take into consideration for performance? Even if we must do large table scans, are there any tips in the most efficient way of doing them? Re: Improve HAVING BY performance Programming Databases by Reverend Jim … about data freshness. > >Partitioning: If your dataset is large, consider partitioning your tables based on certain criteria (e.g… queries involving the HAVING clause, especially for complex aggregations on large datasets. > >By applying these strategies, you can improve… Improve HAVING BY performance Programming Databases by Dani What are some ways to improve MySQL performance on queries against large tables that include the HAVING BY clause. It's my understanding that anything in there doesn't benefit from table indexes. Re: How to Code a Load More Button? Digital Media Digital Marketing Search Engine Strategies by MarkMarketer …; button is a common feature when it comes to handling large data sets. The idea is to load a small amount… Re: Improve HAVING BY performance Programming Databases by Reverend Jim I'm not very familiar with HAVING but my understanding is that it is used to filter results after a GROUP operation so I can't imagine that indexes would improve performance other than on the original SELECT. Using WHERE would return rows based on one or more criteria, and would benefit from indexing, but HAVING, as I understand, is performed after… Re: Improve HAVING BY performance Programming Databases by pritaeas Perhaps a smarter someone on this forum can help you look at the execution plan of your query and suggest some improvements. Re: Improve HAVING BY performance Programming Databases by Dani Everything there is very generic and, dare I say, robotic, and doesn't really answer my question as to if any MySQL experts out there have come up with any creative tips they'd like to share from their own experience. I would have been much more interested in what your friend had to say from his firsthand experience than what ChatGPT has to say.… Re: Improve HAVING BY performance Programming Databases by Reverend Jim Clearly you missed the part where my friend said, it's the same answer he would have given. In other words, the answer generated by ChatGPT was vetted by an expert. I do not understand your response in this case. If I were to post a code project here, and that project happened to contain a ChatGPT generated function, would that be a no-no in … Re: Improve HAVING BY performance Programming Databases by Reverend Jim If I had taken the ChatGPT reply, reworded, then posted it, would that have been OK? Or would that be plagiarism? What if I posted my reworded version AND credited it as a rewording of a ChatGPT generated answer? Then that just makes me look like an idiot. Where is the line? Re: Improve HAVING BY performance Programming Databases by Reverend Jim >see if you can convert it to a WHERE clause I made a foolish assumption that the HAVING was something that depended on the GROUPing and thus could not be converted to w WHERE. As for my expert, I also assumed that if he could have been more specific he would have been. That would have required more info on your specific situation. May I … Re: Improve HAVING BY performance Programming Databases by Dani > Clearly you missed the part where my friend said, it's the same answer he would have given. No, you didn't say it's the same answer he would have given. You said it's what he would have written *if he spent a lot of time researching.* There's a big difference between asking an industry expert for their personal opinion based on their own … Re: Improve HAVING BY performance Programming Databases by Dani I'll give you another example. I've been going to the doctor a lot lately. After each appointment, there is a long form summary of everything that was said, test results, interpretation of the test results, and next steps, all generally typed up by a medical student or resident. At the bottom it has my doctor's signature saying something along … Re: Improve HAVING BY performance Programming Databases by Reverend Jim I asked someone who is an acknowledged expert (not just by me). He agreed with the generated answer. If I had instead written him that advice, letting him believe it was mine, he would have given the same response. In other words, it was most definitely not simply AI generated garbage. If I asked ChatGPT and my doctor what to do for a particular… Re: Improve HAVING BY performance Programming Databases by Dani What your expert friend would have written, had he been a forum member here, is different than what the AI wrote. Even if the overall sentiment is the same, the actual typed words coming from a human are different than those coming from an AI. While he *agreed* with the generated answer, it's not what he would have answered himself upon being … Re: Improve HAVING BY performance Programming Databases by Dani > Now you are just splitting hairs I don't think so, but let's just agree to disagree. Re: Improve HAVING BY performance Programming Databases by AndreRet And so the queen bee has spoken again, no matter the input or consideration from others. IMHO Reverend Jim were not out of line here, merely posted a scenario which could have helped... I truly saw/hoped for a turn around on the site but it seems to be governed by a "my way or the highway" mindset. Through some years I have really tried … Re: Improve HAVING BY performance Programming Databases by Dani I see it very differently than you see it. I consider Jim a real world friend of mine, as is his son, Adam, who I had actually invited to my wedding. I didn't bash Jim with my moderator nor admin nor forum owner hat on. He contributed a post where I disagree with his viewpoint. He disagrees with mine. We had a public debate about it. I took … Re: Improve HAVING BY performance Programming Databases by Reverend Jim >We "bashed" viewpoints, and never each other As it should be. I wish this applied to the real world on a broader scale (we all know who I am talking about). >I would hope that's the way Jim took it too Absolutely. Dani is a respected friend and I always appreciate her viewpoint whether I agree or disagree with it. And I … Retrieval Augmented Generation (RAG) with Google Gemma From HuggingFace Programming Computer Science by usmanmalik57 … will explain how you can improve performance of a pretrained large language model (LLM) using retrieval augmented generation (RAG) …huggingface.co/thenlper/gte-large) from HuggingFace. ``` embedding_model = SentenceTransformer("thenlper/gte-large") model_path = "thenlper/gte-large" embeddings = HuggingFaceEmbeddings… Fine Tuning Google Gemma Model for Text Classification in Python Programming Computer Science by usmanmalik57 …/gemma), a family of state-of-the-art open-source large language models (LLMs). As per initial results, its 7b (seven… hours. LoRa is a common approach for fine-tuning very large language models. The following script sets the LoRa configuration for… Re: what's the correct way of learning programming? Programming by Reverend Jim …. Python has a very friendly syntax and there are a large number of free online tutorials. And you can post questions… for things that are unclear. I've programmed in a large number of languages over many years and I now program… Re: Postfix authentication problem Hardware and Software Linux and Unix by chickenbirds … the purpose of relaying emails from a web application to large mail providers like gmail, which then deliver the mail. I… With All the Hype Around AI, Be Cautious Where Your Tax Money Goes Community Center by Johannes C. … considered successful**. The same analysis found that 52% of large projects were "challenged", and 41.4% as… should raise alarms about the efficiency and appropriate use of large-scale IT investments, especially in AI. ## Big Money… for those in charge of public spending to waste large sums on AI projects with little substance, or on… Choosing the Right Framework: Comparing Pros and Cons Programming by riyajohnson70 …, which make it easier to build and maintain large-scale applications. Additionally, React's virtual DOM implementation… features. Angular provides a complete solution for building large-scale applications and supports two-way data binding,…and performance can be an issue for applications with large data sets. Vue is a lightweight framework with… Re: Choosing the Right Framework: Comparing Pros and Cons Programming by trueframe … efficiency of your development. Community support: Popular frameworks often have large developer communities that provide extensive resources, tutorials, and troubleshooting help… Trump Returns & A Good Year for BTC: ChatGPT’s Bold Predictions for 2024 Community Center by Johannes C. …://static.daniweb.com/attachments/4/ba0b52e08c3a8a560278083de1d5aa38.jpg) "As a Large Language Model, I am not programmed to see into the… Comparing Google Gemini Pro with OpenAI GPT-4 for Zero-Shot Classification Programming Computer Science by usmanmalik57 … this article, we will compare two state-of-the-art large language models for zero-shot text classification: [Google Gemini Pro… Use of the Word ‘Tapestry’ in Web News More Than Doubled Last Year Community Center by Johannes C. …'t worry. This text has not been generated by a Large Language Model (LLM). Much of what you find on the… Converting PDF Image to CSV Using Multimodal Google Gemini Pro Programming Computer Science by usmanmalik57 … the Google Gemini Pro, a state-of-the-art multimodal large language model, to extract information from a receipt image. You…