To Split or Not to Split: Should I split one website into multiple?

I have a website that's been around for over 13 years built on WordPress. Let's say it's about video games (it's not but it will serve as an analogy.) It's a news and reviews website – not a store or business. Revenue is all from ads. DA 61, for reference on age/size/popularity.

tl;dr: Is it OK to split an old website into multiple new ones (splitting off a new niche from the old general site), copy over the posts related to the new niche, and 301 redirect the old posts to the new…​

To Split or Not to Split: Should I split one website into multiple?

Split PDF with Multiple Page Ranges and Multiple Outputs

I need to split 1 PDF file into multiple PDFs, but using specific page ranges.

This CPDF command will split multiple page ranges, but merge them into 1 PDF file.

cpdf in.pdf 1-3,90-97,112-end -o out.pdf

I need a command that will carry out a similar function to the above command, but output each page range to its own PDF.

I’ve looked for solutions to this problem in the PDFTK and CPDF documentation, but haven’t found any help.

Is it faster to split a large table into 12 rolling monthly tables & use UNION them for reports or keep large table & delete rows older than 1 year?

My co-worker wants to split a large 158M row stats table into stats_jan, stats_feb, … and use UNION to select from them for reports. Is that standard practice and is it faster than to just use the large table in place and delete rows older than one year? The table is many small rows.

mysql> describe stats; +----------------+---------------------+------+-----+---------+----------------+ | Field          | Type                | Null | Key | Default | Extra          | +----------------+---------------------+------+-----+---------+----------------+ | id             | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment | | badge_id       | bigint(20) unsigned | NO   | MUL | NULL    |                | | hit_date       | datetime            | YES  | MUL | NULL    |                | | hit_type       | tinyint(4)          | YES  |     | NULL    |                | | source_id      | bigint(20) unsigned | YES  | MUL | NULL    |                | | fingerprint_id | bigint(20) unsigned | YES  |     | NULL    |                | +----------------+---------------------+------+-----+---------+----------------+ 

I did manually split the table up and copy the rows into the appropriate month tables and created a giant UNION query. The large UNION query took 14s versus 4.5m for the single table query. Why would many smaller tables take a significantly shorter time than one large table, when it’s the same number of rows total?

create table stats_jan (...); create table stats_feb (...); ... create index stats_jan_hit_date_idx on stats_jan (hit_date); ... insert into stats_jan select * from stats where hit_date >= '2019-01-01' and hit_date < '2019-02-01'; ... delete from stats where hit_date < '2018-09-01'; ... 

The monthly tables have from 1.7M rows to 35M rows.

select host as `key`, count(*) as value from stats join sources on source_id = sources.id where hit_date >= '2019-08-21 19:43:19' and sources.host != 'NONE' group by source_id order by value desc limit 10; 4 min 30.39 sec  flush tables; reset query cache;  select host as `key`, count(*) as value from stats_jan join sources on source_id = sources.id where hit_date >= '2019-08-21 19:43:19' and sources.host != 'NONE' group by source_id UNION ... order by value desc limit 10; 14.16 sec 

AWK: split file and pipe output to other command

Consider this file:

#!/usr/bin/env bash cat > example_file.txt <<EOL |dms,wew,qwqw| |m|head1| |3,4,6|423|ew2,422.12,ged| |3e,2,23| |m|head1| |314,26|432|ew2d,11422.12,plk| |xw,12,2123| |23,d,213| |23,22q,2skl| |m|head1| |3sdd,126|543|klrs,98322,as02| |dljs,wqpw,2;a| |dllw,w1p,1q;a| EOL 

I would like to split it into chunks on the split line, which in this case is the string |m|head1|. As in this command:

awk '/^|m|head1||/ {OUT=substr($  0,2) ".fa"}; {print >> OUT; close(OUT)}' example_file.txt 

However, I would like the split files to be redirected to another awk command, as opposed to being written to disk. E.g. I’m trying to design a pipeline and the split is more in the middle than the end:

zcat example_file.txt.gz | awk '/^|m|head1||/ ????' | awk ...' 

(The question marks indicate the part I have not been able to do.)

Split a text string into two columns ms access 2013

Hello everyone and thank you very much for your support in this question. I have a table that has this structure and values Table: F_FAC Source table

The F_FAC table has two fields (in fact more, but these are the necessary ones), I need to convert the expiration field (VENFAC) into two fields by exporting the result into a new table called FAC_TEMP as follows: Table FACTEXP

How I need to organized data

What I mean is that I must divide the text string to create a record, place the code, the date in one column (EXPDATE) and the value in another (VALUE), create a new record with the code the second date and the second amount and so on, the challenge that I have not yet been able to achieve is to keep the unique identifier of each invoice (COD field) and the values ​​of the chain to be divided, taking into account that in the example, the invoice code No. 25 has one due date and the invoice with code No. 26 has three due dates (And there may be invoices with up to six due dates as I show)

I have tried using the following code, but the result does not work:

Public Sub ObtenerVencimientos()  Dim rs As DAO.Recordset Dim rs_out As DAO.Recordset Dim x As Long Dim ListaVence() As String      Set rs = CurrentDb.OpenRecordset("SELECT CODFAC,VENFAC FROM F_FAC")     Set rs_out = CurrentDb.OpenRecordset("FAC_TEMP")     With rs         Do             ListaVence = Split(!VENFAC, ";")             For x = LBound(ListaVence) To UBound(ListaVence)                 rs_out.AddNew                 rs_out!CODFAC = rs!CODFAC                 rs_out!VENFAC = ListaVence(x)                 [b]rs_out!VALUE = ' here I should place the amount[/b]                 rs_out.Update             Next x             .MoveNext         Loop Until .EOF     End With      rs_out.Close     Set rs_out = Nothing     rs.Close     Set rs = Nothing      MsgBox "Done"  End Sub 

The Wrong result I get is this:

Wrong result

Thanks for all the help you can give me!!!

Split de cadena con Regex manteniendo el delimitador

Tengo una cadena que me llega en JSON con unos datos como estos

{“name”:”AMD”,”history”:{“2019-09-05”:{“open”:”31.79″,”close”:”31.50″,”high”:”32.05″,”low”:”31.12″,”volume”:”57693493″},”2019-09-04″:{“open”:”31.32″,”close”:”30.95″,”high”:”31.83″,”low”:”30.85″,”volume”:”46709780″},”2019-09-03″:{“open”:”30.83″,”close”:”30.90″,”high”:”31.14″,”low”:”30.68″,”volume”:”38080254″}, … etc

usando

 string[] cotizacion = Regex.Split(cadena_url, @"\d{4}\-\d{2}\-\d{2}"); 

Me genera correctamente un elemento en el array cotizacion por cada dia, el problema es que el split elimina la fecha y a mi me interesa que se mantenga la fecha y la añada al array.

No consigo añadir la fecha al array.

Muchas gracias por la ayuda.

Split your PDFs online

Friends,
Here's one more useful online tool to split your PDF online. This is a very fast, easy and reliable tool – http://splitpdf.online for splitting a PDF document into several pages. With its new generation algorithms, you will get the result of the highest quality. All the pages will be split without quality loss, errors, and correct. There is no limit on the number of pages, and their quality.

Try it and share your views and suggestions.

How does Split Ray apply to Light of Lunia?

I stumbled across the Light of Lunia spell in the Spell Compendium (p132) and was wondering how exactly Metamagic would apply to it. Split Ray in particular interests me, as I would love a way to get an additional ray out of it.

Light of Lunia

Evocation [Good, Light]
Level: Celestia 1, Cleric 1, Sorcerer/Wizard 1,
Components: V, S
Casting Time: 1 standard action
Range: Medium (100 ft. + 10 ft./level)
Target: You and up to two rays; see text
Duration: 10 minutes/level (D) or until discharged; see text
Saving Throw: None
Spell Resistance: Yes; see text

You invoke the powers of good and you begin to glow with the silver light of fabled Lunia, the first layer of the Seven Mounting Heavens of Celestia.
The silvery radiance created by this spell emanates from you in a 30-foot radius, and dim light extends for an additional 30 feet.
Beginning one turn after you cast this spell, you can choose to expend some or all of the light of Lunia as a ray of light. You must succeed on a ranged touch attack with the ray to strike a target. You can make a single ranged touch attack that deals 1d6 points of damage, or 2d6 points of damage against undead or evil outsiders, with a range of 30 feet. Spell resistance applies to this attack. This dims your silvery radiance to half (15-foot light, with dim light for an additional 15 feet). You can choose to fire one additional ray with the same characteristics either on the same round or on a subsequent round. Firing the second ray quenches your radiance and ends the spell.

Split map|content layout, should the map be on the left or right side?

It’s split down the middle; left side for the map, and content loads on the right side when the user clicks on a pin.

I got some opinions, and notably their initial reaction is “Why is the map on the left? Hmm, well I guess that kinda makes sense since it’s left to right”.

If I had to point a finger, I’d say the initial expectation for map on the right and content on the left comes from Google Maps’ layout.

So should the map stay on the left side? Or move it to the right side?