Blog

Hi, I run Cloudlinux 6 and cPanel, MYSQL 5.7. When i visit home.php from my forum it loads forever and mysql seems to "crash". The only th… | Read the rest of http://www.webhostingtalk.com/showthread.php?t=1734111&goto=newpostRead more

Suppose I have got a list of numbers (say x-y coordinates) a={{-99.107159975257815156, 0}, {-99.107159975199010630, 0}, {-99.107142118737087314, 0}, {-99.107142118737058893, 0}, {-99.107142118737058893, 0}, {-98.809552110008141289, 0}, {-95.833332619319349971, 0}, {-95.535743059443774445, 0}, {-95.238127643771221612, 0}, {-94.345237392311275941, 0}, {-93.067528042225021040, 0}, {-91.964285029098363129, 0}, {-91.666688282908694448, 0}, {-90.931371871528057200, 0}, {-90.608464933379565328, 0}, {-90.476189802090317444, 0}, {-90.476189802090317444, 0}, {-90.178570756688671413, 0}, {-89.583351887655183554, 0}, {-89.583332665885464525, 0}} As we can seeRead more

I am working on a java server, which has a bunch of seemingly distinct “services”. A lot of which are just effectively classes. From a software architecture point of view I wonder what the opinion is on such a setup. Is there any advantage to be gained by splitting the related services off into theirRead more

I have a item file with one item per record and a detail file with many customers with many descriptions. Each customer can have many items. Each item can have many customers. File 1 Item ID File 2 Item ID Customer Number I am trying to get a list of item IDs with only oneRead more

I am wondering if there are ways of defining “structure” on infinite sets that generate sequences of cardinals distinct from either the $ \aleph$ or $ \beth$ numbers? Let me explain: Start by defining $ \beth_0=|\mathbb N|$ , which then is also the cardinality of any other countably infinite set. Next use the power setRead more

I have a relatively large SQLite database that I’m building. The general access profile of this database is: Initial load of 300 million rows. Initial read of each row, and UPDATE on approximately 30 million rows Ongoing read-only access through a python script with a MyDatabaseReader class. The data structure is a flat denormalized tableRead more

The definition of an element of the fundamental group of a space $ X$ based at point $ p$ is $ $ f:[0,1]\rightarrow X,\quad f(0)=p=f(1),$ $ defined up to homotopy. This homotopy allows self-intersection, so that there is no sense in thinking about images of loops as knots. Suppose we were to constrain the homotopyRead more

I have the following SQL: SELECT DISTINCT t1.revenue_code, listagg(t1.city_fips,’,’) WITHIN GROUP (ORDER BY t1.city_fips) AS cities, rtrim(xmlagg (XMLELEMENT(e, t1.house,’,’).EXTRACT(‘//text()’) ).getclobval(),’,’) AS houses FROM warehousetable01 t1 WHERE t1.rep_id = 1234567890 GROUP BY t1.revenue_code ORDER BY cities; In the above query, houses contains a list of non-unique values. The query executes without error but I need toRead more

I use MySQL 5.7 and the following query (derived from drupal 7): select distinct node.nid, node.title, node.changed, users_node.name from node left join users users_node on node.uid = users_node.uid order by node.nid desc limit 4; In some servers the results look like this which seems correct: +—–+—————————-+————+——+ | nid | title | changed | name |Read more

So, I’ve been looking at this database code and there is a specific section in the code where a table is created using select distinct on multiple variables and it seems to run forever when trying to get through this process on a remote computer when I run the program. Is there a better wayRead more