Sean Fisher seanfisher

## Description.md

      
              2 files
            
          
              1 fork
            
          
              0 comments
            
          
              18 stars
            
          
                Zhentar
                / Description.md
            
            
              Last active
              March 1, 2024 04:35
            
              
                I knew the Span<T> stuff was supposed to be fast, but this is ridiculous!
              
          
    I have a program that parses data from both delimited files and Excel spreadsheets. I was trying out Span to speed up parsing the delimited files, but the ref struct restrictions mean I can't just hide the two different file formats behind an interface (without the small added overhead of repeatedly pulling Spans from Memory).
But what if I just wrote the ASCII strings from the Excel spreadsheets into a byte buffer, so that the same Span based parser could be used with both file formats? Seems like the overhead cost could be fairly low, and the Excel parsing is already intrinsically slower because of the decompression & XML parsing costs, so I'd be willing to take a small performance hit there for a big gain on the delimited files.
BenchmarkDotNet=v0.10.14, OS=Windows 10.0.17134
Intel Core i7-6600U CPU 2.60GHz (Skylake), 1 CPU, 4 logical and 2 physical cores
.NET Core SDK=2.1.301
[Host] : .NET Core 2.1.1 (CoreCLR 4.6.26606.02, CoreFX 4.6.26606.05), 64bit RyuJIT

  
## contact.html
<html>
  <head>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
    <script>
     function submitToAPI() {
       var URL = ‘/contact’;
       var data = {
         name: $(‘#name-input’).val(),
         email: $(‘#email-input’).val(),
         description: $(‘#description-input’).val()

## IQueryableExtensions
public static class IQueryableExtensions
{
    private static readonly TypeInfo QueryCompilerTypeInfo = typeof(QueryCompiler).GetTypeInfo();

    private static readonly FieldInfo QueryCompilerField = typeof(EntityQueryProvider).GetTypeInfo().DeclaredFields.First(x => x.Name == "_queryCompiler");

    private static readonly PropertyInfo NodeTypeProviderField = QueryCompilerTypeInfo.DeclaredProperties.Single(x => x.Name == "NodeTypeProvider");

    private static readonly MethodInfo CreateQueryParserMethod = QueryCompilerTypeInfo.DeclaredMethods.First(x => x.Name == "CreateQueryParser");

## docker-npm.js
'use strict'

// ideal for use with AWS Lambda and native Node.js modules

// requires Docker: https://docs.docker.com/engine/installation/

/*
Usage:
  node docker-npm.js install
  node docker-npm.js rebuild

## fix-google-drive-dark-mode-icons.sh
#!/bin/bash

function switch_files {
    mv $1.png $1.tmp.png
    mv $1-inverse.png $1.png
    mv $1.tmp.png $1-inverse.png
    mv $1@2x.png $1@2x.tmp.png
    mv $1-inverse@2x.png $1@2x.png
    mv $1@2x.tmp.png $1-inverse@2x.png
}
	<html>
	<head>
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
	<script>
	function submitToAPI() {
	var URL = ‘/contact’;
	var data = {
	name: $(‘#name-input’).val(),
	email: $(‘#email-input’).val(),
	description: $(‘#description-input’).val()
	public static class IQueryableExtensions
	{
	private static readonly TypeInfo QueryCompilerTypeInfo = typeof(QueryCompiler).GetTypeInfo();

	private static readonly FieldInfo QueryCompilerField = typeof(EntityQueryProvider).GetTypeInfo().DeclaredFields.First(x => x.Name == "_queryCompiler");

	private static readonly PropertyInfo NodeTypeProviderField = QueryCompilerTypeInfo.DeclaredProperties.Single(x => x.Name == "NodeTypeProvider");

	private static readonly MethodInfo CreateQueryParserMethod = QueryCompilerTypeInfo.DeclaredMethods.First(x => x.Name == "CreateQueryParser");
	'use strict'

	// ideal for use with AWS Lambda and native Node.js modules

	// requires Docker: https://docs.docker.com/engine/installation/

	/*
	Usage:
	node docker-npm.js install
	node docker-npm.js rebuild
	#!/bin/bash

	function switch_files {
	mv $1.png $1.tmp.png
	mv $1-inverse.png $1.png
	mv $1.tmp.png $1-inverse.png
	mv $1@2x.png $1@2x.tmp.png
	mv $1-inverse@2x.png $1@2x.png
	mv $1@2x.tmp.png $1-inverse@2x.png
	}