Tag: query

Feed: Planet PostgreSQL. Published: Sun 05 August 2018 By Brian Davis In Posts. tags: postgresql How expensive is a join? It depends! It depends what the join criteria is, what indexes are present, how big the tables are, whether the relations are cached, what hardware is being used, what configuration parameters are set, whether statistics are up-to-date, what other activity is happening on the system, to name a few things. But we can still try and get a feel for what a couple simple scenarios look like and see what happens when: The number of tables being joined increases The ... Read More

Feed: Neo4j Graph Database Platform. Author: Mark Needham. Welcome to this week in Neo4j where we round up what’s been happening in the world of graph databases in the last 7 days. This week we have the release of Graphileon Personal Edition, a new Getting Started with Neo4j YouTube series, Intuitive Detections Research with Neo4j, we learn how to build the user timeline of a Neo4j based dating site, and more! This week’s featured community member is Brian Underwood, Platform Engineer at Fishbrain. Brian Underwood – This Week’s Featured Community Member He has been instrumental for the Ruby community, taking ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Borys Belinsky | August 17, 2018 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.6.41-84.1 on August 17, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.6.41, including all the bug fixes in it. Percona Server for MySQL 5.6.41-84.1 is now the current GA release in the 5.6 series. All of Percona’s software is open-source and free. Bugs Fixed A simple SELECT query on a table with CHARSET=euckr COLLATE=euckr_bin could return different results each ... Read More

Feed: SAS Blogs. Author: Warren F. Kuhfeld. Have you ever wanted to see examples of all of the output styles that SAS provides, or have you ever wondered what the attribute priority is for every style? It is hard to make an informed choice about styles if you can't see output that uses them. Maybe Meadow is the perfect style for you, but you would never know it if you can't see it. You can run this program and look at the resulting file, styles.html, to see an example of output that uses each style. This post explains more about ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL Users, MySQL Connector/J 5.1.47, a maintenance release of the production 5.1branch has been released. Connector/J is the Type-IV pure-Java JDBCdriver for MySQL. MySQL Connector/J is available in source and binary form from theConnector/J download pages athttp://dev.mysql.com/downloads/connector/j/5.1.htmland mirror sites as well as Maven-2 repositories. MySQL Connector/J (Commercial) is already available for download onthe My Oracle Support (MOS) website. This release will shortly beavailable on eDelivery (OSDC). As always, we recommend that you check the “CHANGES” file in thedownload archive to be aware of changes in behavior that might affectyour application. MySQL Connector/J 5.1.47 includes ... Read More

Feed: Planet PostgreSQL. Citus has multiple different excutors which each behaving differently to support a wide array of use cases. For many the notion distributed SQL seems like it has to be a complicated one, but the principles of it aren’t rocket science. Here we’re going to look at a few examples of how Citus takes standard SQL and transforms it to operate in a distributed form so it can be parallelized. The result is that you can see speed up of 100x or more in query performance over a single node database. How do we know something is distributed ... Read More

Feed: Planet MySQL; Author: Mikael Ronström; Second chapter of "MySQL Cluster 7.5 inside and out".When I started developing the ideas for NDB Cluster in my Ph.D studies about 25 years ago, the first thing I did was to perform a very thorough study of the requirements.At that time I participated in a European Research for UMTS. UMTS was later marketed as 3G. My part of this big study group of more than 100 researchers was to simulate the network behaviour. We used the protocols developed by other groups to see what the load would be on the various nodes in the ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . Power BI now offers enhanced filtering capabilities that let you define more complex report-level filters as query string parameters directly in the report URL, as the following screenshot illustrates. This example shows the Retail Analysis sample with a report-level filter to display results only for the item category “050-Shoes”, for the year 2014 (the last year with data in this sample solution), and only for new stores in the sales territories of Kentucky and Ohio. You can see the applied report-level filter in the Filters pane. The following query ... Read More

Feed: MemSQL Blog. Author: Kaan Erdener. In 2016, Pandora chose MemSQL to serve as the data store and foundation for solving a specific business problem. In this post, we explore: The Business Problem — what were we trying to solve? The Previous System — a few details Requirements — business requirements (and a few technical ones too) The Contenders — what did the options look like About MemSQL How We Implemented MemSQL Data Strategy: Columnstore vs. Rowstore Hardware Details Into the Weeds Summary The Business Problem The first step in finding a solution is to clearly define the problem. The goal was not to find some way to ... Read More

Feed: Blog. Author: Scott Stone; We are pleased to announce the general availability of SQL Diagnostic Manager 10.3. Existing users may upgrade to this version through the Idera Customer Portal. New users may download the trial version from the Idera Website. This release includes the following features:This release adds the following features: Minimize Privilege Requirements for monitoring.  – Enable monitoring of SQL Server with reduced privileges with scripts provided for recommended privilege level and minimum privilege level. Operator Security Role – Additional security role within SQL Diagnostic Manager targeted to the needs of contracted off-hours DBAs while restricting unneeded configuration access. Grooming ... Read More