From f4b0d76cd4ae936a1d327c8a06adf0f50a80b8ad Mon Sep 17 00:00:00 2001 From: tobi <31960611+tsmethurst@users.noreply.github.com> Date: Wed, 18 May 2022 16:58:26 +0200 Subject: [performance] Add further indexes to mitigate laggy queries (#586) * start adding more indexes as a migration * update sqlite version --- vendor/modernc.org/libc/utime/capi_freebsd_386.go | 2 +- .../modernc.org/libc/utime/capi_freebsd_amd64.go | 2 +- vendor/modernc.org/libc/utime/capi_netbsd_amd64.go | 2 +- .../modernc.org/libc/utime/capi_openbsd_amd64.go | 2 +- vendor/modernc.org/libc/utime/utime_freebsd_386.go | 28 +++++++++++----------- .../modernc.org/libc/utime/utime_freebsd_amd64.go | 26 ++++++++++---------- .../modernc.org/libc/utime/utime_netbsd_amd64.go | 20 ++++++++-------- .../modernc.org/libc/utime/utime_openbsd_amd64.go | 26 ++++++++++---------- 8 files changed, 54 insertions(+), 54 deletions(-) (limited to 'vendor/modernc.org/libc/utime') diff --git a/vendor/modernc.org/libc/utime/capi_freebsd_386.go b/vendor/modernc.org/libc/utime/capi_freebsd_386.go index 73ceebf9c..6ef109032 100644 --- a/vendor/modernc.org/libc/utime/capi_freebsd_386.go +++ b/vendor/modernc.org/libc/utime/capi_freebsd_386.go @@ -1,4 +1,4 @@ -// Code generated by 'ccgo utime/gen.c -crt-import-path -export-defines -export-enums -export-externs X -export-fields F -export-structs -export-typedefs -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -o utime/utime_freebsd_386.go -pkgname utime', DO NOT EDIT. +// Code generated by 'ccgo utime/gen.c -crt-import-path -export-defines -export-enums -export-externs X -export-fields F -export-structs -export-typedefs -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -ignore-unsupported-alignment -o utime/utime_freebsd_386.go -pkgname utime', DO NOT EDIT. package utime diff --git a/vendor/modernc.org/libc/utime/capi_freebsd_amd64.go b/vendor/modernc.org/libc/utime/capi_freebsd_amd64.go index 88dc9f354..44faae56a 100644 --- a/vendor/modernc.org/libc/utime/capi_freebsd_amd64.go +++ b/vendor/modernc.org/libc/utime/capi_freebsd_amd64.go @@ -1,4 +1,4 @@ -// Code generated by 'ccgo utime/gen.c -crt-import-path -export-defines -export-enums -export-externs X -export-fields F -export-structs -export-typedefs -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -o utime/utime_freebsd_amd64.go -pkgname utime', DO NOT EDIT. +// Code generated by 'ccgo utime/gen.c -crt-import-path -export-defines -export-enums -export-externs X -export-fields F -export-structs -export-typedefs -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -ignore-unsupported-alignment -o utime/utime_freebsd_amd64.go -pkgname utime', DO NOT EDIT. package utime diff --git a/vendor/modernc.org/libc/utime/capi_netbsd_amd64.go b/vendor/modernc.org/libc/utime/capi_netbsd_amd64.go index bddece8e4..970e17122 100644 --- a/vendor/modernc.org/libc/utime/capi_netbsd_amd64.go +++ b/vendor/modernc.org/libc/utime/capi_netbsd_amd64.go @@ -1,4 +1,4 @@ -// Code generated by 'ccgo utime/gen.c -crt-import-path -export-defines -export-enums -export-externs X -export-fields F -export-structs -export-typedefs -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -o utime/utime_netbsd_amd64.go -pkgname utime', DO NOT EDIT. +// Code generated by 'ccgo utime/gen.c -crt-import-path -export-defines -export-enums -export-externs X -export-fields F -export-structs -export-typedefs -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -ignore-unsupported-alignment -o utime/utime_netbsd_amd64.go -pkgname utime', DO NOT EDIT. package utime diff --git a/vendor/modernc.org/libc/utime/capi_openbsd_amd64.go b/vendor/modernc.org/libc/utime/capi_openbsd_amd64.go index b27f5a5f8..89e511345 100644 --- a/vendor/modernc.org/libc/utime/capi_openbsd_amd64.go +++ b/vendor/modernc.org/libc/utime/capi_openbsd_amd64.go @@ -1,4 +1,4 @@ -// Code generated by 'ccgo utime/gen.c -crt-import-path -export-defines -export-enums -export-externs X -export-fields F -export-structs -export-typedefs -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -o utime/utime_openbsd_amd64.go -pkgname utime', DO NOT EDIT. +// Code generated by 'ccgo utime/gen.c -crt-import-path -export-defines -export-enums -export-externs X -export-fields F -export-structs -export-typedefs -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -ignore-unsupported-alignment -o utime/utime_openbsd_amd64.go -pkgname utime', DO NOT EDIT. package utime diff --git a/vendor/modernc.org/libc/utime/utime_freebsd_386.go b/vendor/modernc.org/libc/utime/utime_freebsd_386.go index 70f170250..7a1411a20 100644 --- a/vendor/modernc.org/libc/utime/utime_freebsd_386.go +++ b/vendor/modernc.org/libc/utime/utime_freebsd_386.go @@ -1,4 +1,4 @@ -// Code generated by 'ccgo utime/gen.c -crt-import-path "" -export-defines "" -export-enums "" -export-externs X -export-fields F -export-structs "" -export-typedefs "" -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -o utime/utime_freebsd_386.go -pkgname utime', DO NOT EDIT. +// Code generated by 'ccgo utime/gen.c -crt-import-path "" -export-defines "" -export-enums "" -export-externs X -export-fields F -export-structs "" -export-typedefs "" -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -ignore-unsupported-alignment -o utime/utime_freebsd_386.go -pkgname utime', DO NOT EDIT. package utime @@ -15,19 +15,19 @@ var _ atomic.Value var _ unsafe.Pointer const ( - X_FILE_OFFSET_BITS = 64 - X_ILP32 = 1 - X_MACHINE__LIMITS_H_ = 0 - X_MACHINE__TYPES_H_ = 0 - X_Nonnull = 0 - X_Null_unspecified = 0 - X_Nullable = 0 - X_SYS_CDEFS_H_ = 0 - X_SYS__TYPES_H_ = 0 - X_TIME_T_DECLARED = 0 - X_UTIME_H_ = 0 - I386 = 1 - Unix = 1 + X_FILE_OFFSET_BITS = 64 // :25:1: + X_ILP32 = 1 // :1:1: + X_MACHINE__LIMITS_H_ = 0 // _limits.h:36:1: + X_MACHINE__TYPES_H_ = 0 // _types.h:42:1: + X_Nonnull = 0 // cdefs.h:790:1: + X_Null_unspecified = 0 // cdefs.h:792:1: + X_Nullable = 0 // cdefs.h:791:1: + X_SYS_CDEFS_H_ = 0 // cdefs.h:39:1: + X_SYS__TYPES_H_ = 0 // _types.h:32:1: + X_TIME_T_DECLARED = 0 // utime.h:43:1: + X_UTIME_H_ = 0 // utime.h:36:1: + I386 = 1 // :335:1: + Unix = 1 // :336:1: ) type Ptrdiff_t = int32 /* :3:26 */ diff --git a/vendor/modernc.org/libc/utime/utime_freebsd_amd64.go b/vendor/modernc.org/libc/utime/utime_freebsd_amd64.go index f00879171..2f4b6ca0e 100644 --- a/vendor/modernc.org/libc/utime/utime_freebsd_amd64.go +++ b/vendor/modernc.org/libc/utime/utime_freebsd_amd64.go @@ -1,4 +1,4 @@ -// Code generated by 'ccgo utime/gen.c -crt-import-path "" -export-defines "" -export-enums "" -export-externs X -export-fields F -export-structs "" -export-typedefs "" -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -o utime/utime_freebsd_amd64.go -pkgname utime', DO NOT EDIT. +// Code generated by 'ccgo utime/gen.c -crt-import-path "" -export-defines "" -export-enums "" -export-externs X -export-fields F -export-structs "" -export-typedefs "" -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -ignore-unsupported-alignment -o utime/utime_freebsd_amd64.go -pkgname utime', DO NOT EDIT. package utime @@ -15,18 +15,18 @@ var _ atomic.Value var _ unsafe.Pointer const ( - X_FILE_OFFSET_BITS = 64 - X_LP64 = 1 - X_MACHINE__LIMITS_H_ = 0 - X_MACHINE__TYPES_H_ = 0 - X_Nonnull = 0 - X_Null_unspecified = 0 - X_Nullable = 0 - X_SYS_CDEFS_H_ = 0 - X_SYS__TYPES_H_ = 0 - X_TIME_T_DECLARED = 0 - X_UTIME_H_ = 0 - Unix = 1 + X_FILE_OFFSET_BITS = 64 // :25:1: + X_LP64 = 1 // :1:1: + X_MACHINE__LIMITS_H_ = 0 // _limits.h:36:1: + X_MACHINE__TYPES_H_ = 0 // _types.h:42:1: + X_Nonnull = 0 // cdefs.h:783:1: + X_Null_unspecified = 0 // cdefs.h:785:1: + X_Nullable = 0 // cdefs.h:784:1: + X_SYS_CDEFS_H_ = 0 // cdefs.h:39:1: + X_SYS__TYPES_H_ = 0 // _types.h:32:1: + X_TIME_T_DECLARED = 0 // utime.h:43:1: + X_UTIME_H_ = 0 // utime.h:36:1: + Unix = 1 // :337:1: ) type Ptrdiff_t = int64 /* :3:26 */ diff --git a/vendor/modernc.org/libc/utime/utime_netbsd_amd64.go b/vendor/modernc.org/libc/utime/utime_netbsd_amd64.go index 56559238a..eca9f7810 100644 --- a/vendor/modernc.org/libc/utime/utime_netbsd_amd64.go +++ b/vendor/modernc.org/libc/utime/utime_netbsd_amd64.go @@ -1,4 +1,4 @@ -// Code generated by 'ccgo utime/gen.c -crt-import-path "" -export-defines "" -export-enums "" -export-externs X -export-fields F -export-structs "" -export-typedefs "" -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -o utime/utime_netbsd_amd64.go -pkgname utime', DO NOT EDIT. +// Code generated by 'ccgo utime/gen.c -crt-import-path "" -export-defines "" -export-enums "" -export-externs X -export-fields F -export-structs "" -export-typedefs "" -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -ignore-unsupported-alignment -o utime/utime_netbsd_amd64.go -pkgname utime', DO NOT EDIT. package utime @@ -15,15 +15,15 @@ var _ atomic.Value var _ unsafe.Pointer const ( - X_AMD64_INT_TYPES_H_ = 0 - X_FILE_OFFSET_BITS = 64 - X_LP64 = 1 - X_SYS_CDEFS_ELF_H_ = 0 - X_SYS_CDEFS_H_ = 0 - X_SYS_COMMON_ANSI_H_ = 0 - X_SYS_COMMON_INT_TYPES_H_ = 0 - X_UTIME_H_ = 0 - X_X86_64_CDEFS_H_ = 0 + X_AMD64_INT_TYPES_H_ = 0 // int_types.h:35:1: + X_FILE_OFFSET_BITS = 64 // :25:1: + X_LP64 = 1 // :268:1: + X_SYS_CDEFS_ELF_H_ = 0 // cdefs_elf.h:31:1: + X_SYS_CDEFS_H_ = 0 // cdefs.h:37:1: + X_SYS_COMMON_ANSI_H_ = 0 // common_ansi.h:33:1: + X_SYS_COMMON_INT_TYPES_H_ = 0 // common_int_types.h:33:1: + X_UTIME_H_ = 0 // utime.h:35:1: + X_X86_64_CDEFS_H_ = 0 // cdefs.h:4:1: ) type Ptrdiff_t = int64 /* :3:26 */ diff --git a/vendor/modernc.org/libc/utime/utime_openbsd_amd64.go b/vendor/modernc.org/libc/utime/utime_openbsd_amd64.go index abc6fbee8..51bb96967 100644 --- a/vendor/modernc.org/libc/utime/utime_openbsd_amd64.go +++ b/vendor/modernc.org/libc/utime/utime_openbsd_amd64.go @@ -1,4 +1,4 @@ -// Code generated by 'ccgo utime/gen.c -crt-import-path "" -export-defines "" -export-enums "" -export-externs X -export-fields F -export-structs "" -export-typedefs "" -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -o utime/utime_openbsd_amd64.go -pkgname utime', DO NOT EDIT. +// Code generated by 'ccgo utime/gen.c -crt-import-path "" -export-defines "" -export-enums "" -export-externs X -export-fields F -export-structs "" -export-typedefs "" -header -hide _OSSwapInt16,_OSSwapInt32,_OSSwapInt64 -ignore-unsupported-alignment -o utime/utime_openbsd_amd64.go -pkgname utime', DO NOT EDIT. package utime @@ -15,18 +15,18 @@ var _ atomic.Value var _ unsafe.Pointer const ( - X_FILE_OFFSET_BITS = 64 - X_LP64 = 1 - X_MACHINE_CDEFS_H_ = 0 - X_MACHINE__TYPES_H_ = 0 - X_MAX_PAGE_SHIFT = 12 - X_RET_PROTECTOR = 1 - X_STACKALIGNBYTES = 15 - X_SYS_CDEFS_H_ = 0 - X_SYS__TYPES_H_ = 0 - X_TIME_T_DEFINED_ = 0 - X_UTIME_H_ = 0 - Unix = 1 + X_FILE_OFFSET_BITS = 64 // :25:1: + X_LP64 = 1 // :1:1: + X_MACHINE_CDEFS_H_ = 0 // cdefs.h:9:1: + X_MACHINE__TYPES_H_ = 0 // _types.h:36:1: + X_MAX_PAGE_SHIFT = 12 // _types.h:52:1: + X_RET_PROTECTOR = 1 // :2:1: + X_STACKALIGNBYTES = 15 // _types.h:49:1: + X_SYS_CDEFS_H_ = 0 // cdefs.h:39:1: + X_SYS__TYPES_H_ = 0 // _types.h:35:1: + X_TIME_T_DEFINED_ = 0 // utime.h:42:1: + X_UTIME_H_ = 0 // utime.h:36:1: + Unix = 1 // :340:1: ) type Ptrdiff_t = int64 /* :3:26 */ -- cgit v1.3