Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 1,000 results for
tables
- Page 1
Image Analysis Using OpenAI GPT-4o Model
Programming
Computer Science
1 Week Ago
by usmanmalik57
… model can also convert graphs into structured data, such as
tables
, as the following script demonstrates. ``` response_content = analyze_graph("Can you…
Re: Extract Tabular Data from PDF Images using Hugging Face Table Transformer
Programming
Computer Science
1 Month Ago
by Harini sri
… compared to other libraries. I have few questions. In some
tables
, I have common column name for three columns and further… I have sub columns like below.... in these cases the
tables
are not getting extracted properly...Do you have any suggestions…
Using Natural Language to Query SQL Databases with Python LangChain Module
Programming
Computer Science
2 Months Ago
by usmanmalik57
… the query. It searches for the `employee`, `salesorder`, and `orderdetail`
tables
to retrieve the required information. You can use the `output…
Re: Improve HAVING BY performance
Programming
Databases
2 Months Ago
by Biiim
… queries with various joins and criteria from 100's of
tables
in less than a second, one is 10 million big…
Re: Improve HAVING BY performance
Programming
Databases
2 Months Ago
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
2 Months Ago
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
2 Months Ago
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 …
Re: 88 Business-Growing Strategies
Digital Media
Digital Marketing
2 Months Ago
by henrymorgan9522
A growth strategy is an organization's plan for overcoming current and future challenges to realize its goals for expansion. Examples of growth strategy goals include increasing market share and revenue, acquiring assets, and improving the organization's products or services.
Re: Improve HAVING BY performance
Programming
Databases
2 Months Ago
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
2 Months Ago
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
2 Months Ago
by Reverend Jim
Was it worth all that for 50ms?
Re: Improve HAVING BY performance
Programming
Databases
2 Months Ago
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
2 Months Ago
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
2 Months Ago
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
2 Months Ago
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
2 Months Ago
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
2 Months Ago
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
2 Months Ago
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: Improve HAVING BY performance
Programming
Databases
2 Months Ago
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
2 Months Ago
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: Improve HAVING BY performance
Programming
Databases
2 Months Ago
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 …
Re: Improve HAVING BY performance
Programming
Databases
2 Months Ago
by Dani
But you're not comparing apples to apples. Your WHERE query and your HAVING query perform different calculations and do different things. In one, you're plucking out all the rows with a price greater than $4, and then calculating an average price for each product. In the other, you're plucking out *all* rows, calculating an average price for each …
Re: Improve HAVING BY performance
Programming
Databases
2 Months Ago
by toneewa
Correct. It wasn't about displaying the results, but to measure the different clauses. I'm not impressed by only 95 INSERTs/sec, and a maximum write speed of 175 KB/s for importing data. Increasing to 50K shows WHERE to be faster. 50K: WHERE Query execution time: 0.0599129 seconds HAVING Query execution time: 0.0621748 …
Re: Improve HAVING BY performance
Programming
Databases
2 Months Ago
by Dani
I think you might be missing my point. If you’re fetching different data, there’s no way of saying whether where or having is faster. You would need to write queries that use each, but retrieve the same data, to see which is faster for a use case. Even then, it totally depends on the data in the database itself. The same query can be fast for some …
Re: Improve HAVING BY performance
Programming
Databases
2 Months Ago
by toneewa
I know when you don't use aggregate calculations use WHERE. Producing the same results can be done. I added another test with MAX(Price). With a database over 305K rows, 3 columns, MySQL Workbench is unstable importing. Took over 2 hours. WHERE is faster, and should be used, when no functions are needed. WHERE Query execution time: 0.…
Re: Improve HAVING BY performance
Programming
Databases
2 Months Ago
by toneewa
I added your mentioned alter table index. Took 4.375 secs in MySQL Workbench. It did speed up the results. I'll have to try another method of importing to see if I can improve this. I also ommitted the overhead of converting variables for display output measurements, because they were included in the C++ times. If we were to compare the two, it as …
Re: Using Natural Language to Query SQL Databases with Python LangChain Module
Programming
Computer Science
1 Month Ago
by aishamushtaq
very helpful
Re: tables vs css
Digital Media
UI / UX Design
14 Years Ago
by drjohn
… in html for displaying
tables
of data. People then tried using them to control the … anyway). Use CSS, it was invented for styling pages. Use
tables
for displaying
tables
of data.
tables please help
Programming
Software Development
19 Years Ago
by mel2005
… c++ with access, i need to create
tables
with access, i can see two
tables
but am sure there another one, i…
Tables
Programming
Software Development
19 Years Ago
by freesoft_2000
…, I have a JTextPane and i am trying to insert
tables
into the JTextPane. I am using the default rtf editor… becomes almost impossible Basically i need a way to insert
tables
into the styled document of the JTextPane something like Microsoft…
1
2
3
17
Next
Last
Search
Search
Forum Categories
Hardware/Software
Recommended Topics
Programming
Recommended Topics
Digital Media
Recommended Topics
Community Center
Recommended Topics
Latest Content
Newest Topics
Latest Topics
Latest Posts
Latest Comments
Top Tags
Topics Feed
Social
Forums
Top Members
Meet People
Community Functions
DaniWeb Premium
Newsletter Archive
Markdown Syntax
Community Rules
Developer APIs
Connect API
Forum API Docs
Tools
SEO Backlink Checker
Legal
Terms of Service
Privacy Policy
FAQ
About Us
Advertise
Contact Us
© 2024 DaniWeb® LLC