SEARCH KEYWORD -- DATABASE SUPPORT


  How to optimize MySQL insert statement

For a big data system, one problem is the data access efficiency, one more problem is that the data insertion is very slow. We had a service system, the data loading process would take 4-5 hours. This time consuming operation is risky since if the program is interrupted during the loading process, it might be rerun, this will be troublesome. So it's necessary to improve the insertion efficiency for big data systems. Here we provide two optimization suggestions. 1. Combine multiple insert stateme...

   MySQL,insert,optimization     2012-10-24 22:03:13

  Select top 3 values from each group in a table with SQL

Yesterday, my friend Liu Bing asked me a question about how to select top 3 values for each person in a database table using SQL. I think this question is interesting and it deserves some thoughts. Here I record down how to solve this issue. Assume we have a table which has two columns, one column contains the names of some people and the other column contains some values related to each person. One person can have more than one value. Each value has a numeric type. The question is we want to se...

   SQL,Correlated query,top 3     2013-05-23 03:21:25

  Unlock Advanced Store Features with Custom Shopify Theme

In the world of e-commerce, a Shopify theme serves as the foundation for a store's visual appeal and functionality. Custom Shopify themes have gained popularity among online retailers looking to stand out in a crowded marketplace. These tailored designs offer unique opportunities to enhance user experience, boost conversions, and align the store's appearance with a brand's identity. The impact of a well-crafted custom Shopify theme extends beyond esthetics, playing a crucial role in a store's ov...

   SHOPIFY ,THEME,SHOPIFY THEME     2024-08-02 11:07:57

  Alibaba launches NASA program

On March 9, the China E-Commerce giant Alibaba held its first internal tech conference in its headquarter Hangzhou. During this conference, Jack Ma, Alibaba founder, announced a new program code named "NASA" which aims to build up technologies serving 2 billion people in next 20 years by forming independent and powerful R&D department. On March 13, Alibaba formerly announced this program to the public. The research area of this program would include machine learning, chi...

   ALIBABA,NASA,CHINA,NEWS     2017-03-13 11:32:22

  Lenovo becomes the king of PC

According to Sina Tech, Data from market research firm IDC and Gartner shows that Lenovo defeats Hewlett-Packard to become the largest PC manufacturer in the world In the second quarter , global PC shipments dropped by 11%, the fifth consecutive quarter of decline.In October 2012, Gartner ranked Lenovo as the world's largest PC manufacturer, but IDC data ranked HP as the largest PC manufacturer. However, the rank of largest PC manufacturer between IDC and Gartner has no difference this time.Gar...

   Lenovo,PC,HP,IDC     2013-07-11 04:52:04

  Use of @font-face

Almost all web browsers(including the dinosaur browser IE6) support the web font property @font-face. Its usage is: @font-face { font-family: 'MyWebFont'; src: url('webfont.eot'); /* IE9 Compat Modes */ src: url('webfont.eot?#iefix') format('embedded-opentype'), /* IE6-IE8 */ url('webfont.woff') format('woff'), /* Modern Browsers */ url('webfont.ttf') format('truetype'), /* Safari, Android, iOS */ url('webfont.svg#svgFontName') format('svg'); /* Legacy iOS */ } Now we...

   CSS,@font-face     2014-06-08 07:17:34

  Why localStorage only allows to store string values

localStorage allows data to be stored in browsers across sessions, the data will be there even though the session is expired. It is frequently used to store static data so that they can be loaded when needed. But as per spec, it says that the keys and the values are always strings (note that, as with objects, integer keys will be automatically converted to strings). Why cannot store the object as it is? Take a look at an example: var str = "test"; localStorage.setItem("str", str); cons...

   JAVASCRIPT,LOCALSTORAGE     2020-04-05 00:54:29

  Use CSS calc to align an element vertically

calc function is a function introduced in CSS3, it can be used to calculate length values. There are a few good features which make it suitable for aligning an element vertically. One good part is that the operands can have different units like percentage, px, rem etc. This makes it very flexible when calculating the length value. One example: .rect{ margin-top:20px; height:50px; background:green; width:calc(100%-20px); } Here the left operand uses percentage while the right one ...

   CSS3,CALC,VERTICAL ALIGN     2019-08-23 20:30:23

  Why is Golang's Compilation Speed So Fast?

Overview When I started learning the Go language, I already had experience with three statically typed languages—C/C++ and Java—and two dynamically typed languages—PHP and JavaScript. Because of this background, when I compiled a demo file of several hundred lines for the first time in Go, I was genuinely impressed by its compilation speed. At that moment, I thought to myself, "Go claims to have the execution speed of statically typed languages and the compilation speed of dyna...

   GOLANG,COMPILATION,GO     2024-10-07 22:02:23

  Tips for a better first-time hackathon experience

Here are a few things you can consider. These are by no means the only way to go about hackathons, just what's worked for me.ProjectI strongly strongly recommend doing something you haven't done before. Even if you're going into a hackathon with the intention of winning, trying something new is always fun and will keep you engaged throughout the event. Jump into mobile development, try hardware hacking, write a compiler, whatever; it's always fun to try out new things.Sticking to things you're c...

   hackathon     2014-03-31 07:25:09

RECENT