# Investigating large latency on a constrained Windows environment

**URL:** <https://discourse.julialang.org/t/investigating-large-latency-on-a-constrained-windows-environment/114482>\
**Category:** General Usage\
**Tags:** startup, ttfp, ttfx, latency\
**Created:** [May 18, 2024, 11:07am UTC](https://discourse.julialang.org/t/investigating-large-latency-on-a-constrained-windows-environment/114482 "2024-05-18T11:07:44Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![ufechner7](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/ufechner7/32/51363_2.png) [@ufechner7](https://discourse.julialang.org/u/ufechner7)\
**Post date:** [May 18, 2024, 11:36am UTC](https://discourse.julialang.org/t/investigating-large-latency-on-a-constrained-windows-environment/114482/3 "2024-05-18T11:36:52Z")

</div>

Can you share the output of

```julia
versioninfo()

```

?

I put your code, excluding the last line (I do not have the file `TerminatedPostcodes.csv`) in a file with the name `init.jl`.

Then I get:

```julia
julia> @time include("init.jl")
  4.588735 seconds (6.71 M allocations: 494.214 MiB, 13.74% gc time, 3.01% compilation time: 86% of which was recompilation)

```

Can you share the .csv file to see if it makes a difference?

UPDATE:  
Just for a test I used this file: [https://www.doogal.co.uk/files/postcodes.zip](https://www.doogal.co.uk/files/postcodes.zip)

Running your code, including reading of the .csv file now takes about 30s.

But if I start Julia with `julia --project -t auto` the time goes down to 11.3 seconds.

If you always need to load this file, converting it to .arrow format once and then load the .arrow file each time can speed things up even more as explained here: [Failing to import (relatively) large CSV file with Julia and VSC - #17 by ufechner7](https://discourse.julialang.org/t/failing-to-import-relatively-large-csv-file-with-julia-and-vsc/112350/17)

---

_[View the full topic](https://discourse.julialang.org/t/investigating-large-latency-on-a-constrained-windows-environment/114482)._