Compress the indexes
Posted: Mon Dec 23, 2024 5:11 am
This query will output a script containing statements that can be run to compress the indexes in the PeopleStage system. It includes all indexes that are over 20000 pages (150Mb) and aren’t already compressed:
(Download .txt file of code here)
get-less-for-nothing-data-2
Run these statement batche cyprus mobile phone numbers to compress the indexes over 150Mb in size. Compression should occur on the smallest index first to maximise available temporary disk space before the largest indexes are compressed.
Apteco was first established in 1987 as a database consultancy. We soon started working on massive databases and our FastStats range of data analysis and campaign automation software was born.
We’ve a dedicated team of developers, support consultants and project managers - all of which are highly talented individuals, and all of which are really rather good with numbers and data. Perhaps none more so than Rob Downs.
As one of our founding directors and director of technology, Rob leads the R&D of the data analysis server at the heart of our FastStats software and is team leader of the R&D group. When he isn’t deep diving into big data he enjoys running long distances over mountains.
In this blog Rob shows his love of math and introduces us to “naturally occurring” numbers and how these can be used within FastStats as a method of highlighting made-up or fraudulent figures.
(Download .txt file of code here)
get-less-for-nothing-data-2
Run these statement batche cyprus mobile phone numbers to compress the indexes over 150Mb in size. Compression should occur on the smallest index first to maximise available temporary disk space before the largest indexes are compressed.
Apteco was first established in 1987 as a database consultancy. We soon started working on massive databases and our FastStats range of data analysis and campaign automation software was born.
We’ve a dedicated team of developers, support consultants and project managers - all of which are highly talented individuals, and all of which are really rather good with numbers and data. Perhaps none more so than Rob Downs.
As one of our founding directors and director of technology, Rob leads the R&D of the data analysis server at the heart of our FastStats software and is team leader of the R&D group. When he isn’t deep diving into big data he enjoys running long distances over mountains.
In this blog Rob shows his love of math and introduces us to “naturally occurring” numbers and how these can be used within FastStats as a method of highlighting made-up or fraudulent figures.