WEBVTT
Kind: captions
Language: en

00:00:02.200 --> 00:00:05.749 align:start position:0%
 
okay<00:00:02.960><c> so</c><00:00:03.280><c> for</c><00:00:03.439><c> our</c><00:00:03.639><c> next</c><00:00:03.879><c> talk</c><00:00:04.319><c> we</c><00:00:04.560><c> have</c><00:00:05.040><c> penj</c>

00:00:05.749 --> 00:00:05.759 align:start position:0%
okay so for our next talk we have penj
 

00:00:05.759 --> 00:00:09.750 align:start position:0%
okay so for our next talk we have penj
to<00:00:06.040><c> give</c><00:00:06.200><c> us</c><00:00:06.399><c> a</c><00:00:06.759><c> talk</c><00:00:07.080><c> on</c><00:00:07.799><c> indexing</c><00:00:08.440><c> entire</c><00:00:08.960><c> 2.4</c>

00:00:09.750 --> 00:00:09.760 align:start position:0%
to give us a talk on indexing entire 2.4
 

00:00:09.760 --> 00:00:12.430 align:start position:0%
to give us a talk on indexing entire 2.4
billion<00:00:10.240><c> transaction</c><00:00:10.960><c> on</c><00:00:11.280><c> ethereum</c><00:00:11.960><c> in</c><00:00:12.160><c> 10</c>

00:00:12.430 --> 00:00:12.440 align:start position:0%
billion transaction on ethereum in 10
 

00:00:12.440 --> 00:00:18.510 align:start position:0%
billion transaction on ethereum in 10
hours<00:00:13.200><c> Let's</c><00:00:13.480><c> welcome</c><00:00:14.120><c> Pang</c><00:00:14.679><c> J</c><00:00:15.160><c> on</c><00:00:15.360><c> the</c>

00:00:18.510 --> 00:00:18.520 align:start position:0%
 
 

00:00:18.520 --> 00:00:20.710 align:start position:0%
 
stage<00:00:19.520><c> thank</c>

00:00:20.710 --> 00:00:20.720 align:start position:0%
stage thank
 

00:00:20.720 --> 00:00:23.109 align:start position:0%
stage thank
[Music]

00:00:23.109 --> 00:00:23.119 align:start position:0%
[Music]
 

00:00:23.119 --> 00:00:27.189 align:start position:0%
[Music]
you<00:00:24.119><c> oh</c><00:00:24.960><c> okay</c><00:00:25.960><c> thank</c>

00:00:27.189 --> 00:00:27.199 align:start position:0%
you oh okay thank
 

00:00:27.199 --> 00:00:31.870 align:start position:0%
you oh okay thank
you<00:00:28.199><c> hello</c><00:00:28.640><c> everyone</c><00:00:29.640><c> uh</c><00:00:29.759><c> my</c><00:00:30.039><c> name</c><00:00:30.119><c> is</c><00:00:30.279><c> pan</c><00:00:31.240><c> so</c>

00:00:31.870 --> 00:00:31.880 align:start position:0%
you hello everyone uh my name is pan so
 

00:00:31.880 --> 00:00:34.950 align:start position:0%
you hello everyone uh my name is pan so
I'm<00:00:32.160><c> Thai</c><00:00:33.079><c> so</c><00:00:33.320><c> as</c><00:00:33.480><c> a</c><00:00:33.680><c> Thai</c><00:00:34.200><c> uh</c><00:00:34.360><c> welcome</c><00:00:34.760><c> to</c>

00:00:34.950 --> 00:00:34.960 align:start position:0%
I'm Thai so as a Thai uh welcome to
 

00:00:34.960 --> 00:00:37.270 align:start position:0%
I'm Thai so as a Thai uh welcome to
Bangkok<00:00:35.600><c> and</c><00:00:35.760><c> Devcon</c><00:00:36.320><c> here</c><00:00:36.480><c> in</c>

00:00:37.270 --> 00:00:37.280 align:start position:0%
Bangkok and Devcon here in
 

00:00:37.280 --> 00:00:41.350 align:start position:0%
Bangkok and Devcon here in
Thailand<00:00:38.280><c> all</c><00:00:38.440><c> right</c><00:00:39.160><c> so</c><00:00:39.559><c> uh</c><00:00:39.879><c> today</c><00:00:40.239><c> I'm</c><00:00:40.840><c> thank</c>

00:00:41.350 --> 00:00:41.360 align:start position:0%
Thailand all right so uh today I'm thank
 

00:00:41.360 --> 00:00:44.190 align:start position:0%
Thailand all right so uh today I'm thank
you<00:00:42.360><c> okay</c><00:00:42.800><c> uh</c><00:00:42.920><c> so</c><00:00:43.079><c> today</c><00:00:43.360><c> I'm</c><00:00:43.480><c> going</c><00:00:43.680><c> to</c><00:00:43.960><c> talk</c>

00:00:44.190 --> 00:00:44.200 align:start position:0%
you okay uh so today I'm going to talk
 

00:00:44.200 --> 00:00:47.630 align:start position:0%
you okay uh so today I'm going to talk
about<00:00:44.719><c> uh</c><00:00:44.879><c> indexing</c><00:00:45.399><c> entire</c><00:00:46.239><c> uh</c><00:00:46.360><c> 2.4</c><00:00:47.239><c> billion</c>

00:00:47.630 --> 00:00:47.640 align:start position:0%
about uh indexing entire uh 2.4 billion
 

00:00:47.640 --> 00:00:51.830 align:start position:0%
about uh indexing entire uh 2.4 billion
transaction<00:00:48.559><c> on</c><00:00:48.800><c> ethereum</c><00:00:49.600><c> in</c><00:00:49.879><c> 10</c><00:00:50.160><c> hours</c><00:00:51.039><c> okay</c>

00:00:51.830 --> 00:00:51.840 align:start position:0%
transaction on ethereum in 10 hours okay
 

00:00:51.840 --> 00:00:55.470 align:start position:0%
transaction on ethereum in 10 hours okay
um<00:00:52.399><c> okay</c><00:00:52.600><c> right</c><00:00:52.760><c> now</c><00:00:52.920><c> it</c><00:00:53.079><c> may</c><00:00:53.280><c> be</c><00:00:54.160><c> like</c><00:00:54.520><c> uh</c><00:00:54.719><c> 2.7</c>

00:00:55.470 --> 00:00:55.480 align:start position:0%
um okay right now it may be like uh 2.7
 

00:00:55.480 --> 00:00:57.430 align:start position:0%
um okay right now it may be like uh 2.7
billion<00:00:55.920><c> right</c><00:00:56.039><c> now</c><00:00:56.239><c> but</c><00:00:56.399><c> at</c><00:00:56.520><c> the</c><00:00:56.719><c> time</c><00:00:57.079><c> it</c><00:00:57.239><c> was</c>

00:00:57.430 --> 00:00:57.440 align:start position:0%
billion right now but at the time it was
 

00:00:57.440 --> 00:01:00.670 align:start position:0%
billion right now but at the time it was
a<00:00:58.039><c> 2.4</c><00:00:59.039><c> okay</c><00:00:59.320><c> let's</c><00:00:59.519><c> get</c><00:00:59.640><c> started</c>

00:01:00.670 --> 00:01:00.680 align:start position:0%
a 2.4 okay let's get started
 

00:01:00.680 --> 00:01:04.429 align:start position:0%
a 2.4 okay let's get started
so<00:01:01.399><c> when</c><00:01:01.719><c> talking</c><00:01:02.160><c> about</c><00:01:03.000><c> uh</c><00:01:03.519><c> indexing</c><00:01:04.199><c> on</c>

00:01:04.429 --> 00:01:04.439 align:start position:0%
so when talking about uh indexing on
 

00:01:04.439 --> 00:01:06.870 align:start position:0%
so when talking about uh indexing on
blockchain<00:01:05.400><c> uh</c><00:01:05.640><c> this</c><00:01:05.920><c> is</c><00:01:06.200><c> the</c><00:01:06.560><c> con</c>

00:01:06.870 --> 00:01:06.880 align:start position:0%
blockchain uh this is the con
 

00:01:06.880 --> 00:01:10.070 align:start position:0%
blockchain uh this is the con
conventional<00:01:07.479><c> way</c><00:01:07.600><c> to</c><00:01:07.759><c> do</c><00:01:07.920><c> it</c><00:01:08.520><c> so</c><00:01:08.880><c> you</c><00:01:09.080><c> have</c><00:01:09.320><c> a</c>

00:01:10.070 --> 00:01:10.080 align:start position:0%
conventional way to do it so you have a
 

00:01:10.080 --> 00:01:13.149 align:start position:0%
conventional way to do it so you have a
database<00:01:10.880><c> that</c><00:01:11.159><c> tracks</c><00:01:12.000><c> uh</c><00:01:12.159><c> the</c><00:01:12.320><c> latest</c><00:01:12.799><c> block</c>

00:01:13.149 --> 00:01:13.159 align:start position:0%
database that tracks uh the latest block
 

00:01:13.159 --> 00:01:17.109 align:start position:0%
database that tracks uh the latest block
that<00:01:13.280><c> you</c><00:01:13.400><c> have</c><00:01:13.880><c> processed</c><00:01:14.880><c> and</c><00:01:15.080><c> then</c><00:01:15.720><c> you</c><00:01:16.439><c> uh</c>

00:01:17.109 --> 00:01:17.119 align:start position:0%
that you have processed and then you uh
 

00:01:17.119 --> 00:01:20.990 align:start position:0%
that you have processed and then you uh
uh<00:01:18.159><c> you</c><00:01:19.159><c> you</c><00:01:19.320><c> call</c><00:01:19.640><c> the</c><00:01:19.840><c> blockchain</c><00:01:20.280><c> node</c><00:01:20.799><c> and</c>

00:01:20.990 --> 00:01:21.000 align:start position:0%
uh you you call the blockchain node and
 

00:01:21.000 --> 00:01:24.069 align:start position:0%
uh you you call the blockchain node and
then<00:01:21.360><c> get</c><00:01:21.560><c> the</c><00:01:21.759><c> data</c><00:01:22.439><c> and</c><00:01:22.640><c> then</c><00:01:23.000><c> update</c><00:01:23.720><c> the</c>

00:01:24.069 --> 00:01:24.079 align:start position:0%
then get the data and then update the
 

00:01:24.079 --> 00:01:28.230 align:start position:0%
then get the data and then update the
that<00:01:24.280><c> block</c><00:01:24.960><c> and</c><00:01:25.119><c> so</c><00:01:25.320><c> on</c><00:01:25.920><c> So</c><00:01:26.119><c> You</c><00:01:26.280><c> Loop</c><00:01:26.720><c> this</c><00:01:27.280><c> uh</c>

00:01:28.230 --> 00:01:28.240 align:start position:0%
that block and so on So You Loop this uh
 

00:01:28.240 --> 00:01:30.390 align:start position:0%
that block and so on So You Loop this uh
uh<00:01:28.439><c> until</c><00:01:28.840><c> you</c><00:01:29.000><c> get</c><00:01:29.159><c> the</c><00:01:29.320><c> latest</c><00:01:29.640><c> block</c><00:01:30.159><c> right</c>

00:01:30.390 --> 00:01:30.400 align:start position:0%
uh until you get the latest block right
 

00:01:30.400 --> 00:01:32.950 align:start position:0%
uh until you get the latest block right
this<00:01:30.479><c> is</c><00:01:30.600><c> a</c><00:01:30.799><c> conventional</c><00:01:31.400><c> way</c><00:01:31.600><c> to</c><00:01:32.119><c> to</c><00:01:32.360><c> work</c><00:01:32.600><c> on</c>

00:01:32.950 --> 00:01:32.960 align:start position:0%
this is a conventional way to to work on
 

00:01:32.960 --> 00:01:34.910 align:start position:0%
this is a conventional way to to work on
the<00:01:33.759><c> blockchain</c>

00:01:34.910 --> 00:01:34.920 align:start position:0%
the blockchain
 

00:01:34.920 --> 00:01:37.870 align:start position:0%
the blockchain
indexer<00:01:35.920><c> but</c><00:01:36.520><c> uh</c><00:01:36.640><c> looking</c><00:01:36.960><c> on</c><00:01:37.200><c> the</c><00:01:37.439><c> product</c>

00:01:37.870 --> 00:01:37.880 align:start position:0%
indexer but uh looking on the product
 

00:01:37.880 --> 00:01:40.510 align:start position:0%
indexer but uh looking on the product
I'm<00:01:38.119><c> working</c><00:01:38.439><c> on</c><00:01:38.720><c> is</c><00:01:38.880><c> called</c><00:01:39.079><c> Alat</c><00:01:39.399><c> tress</c><00:01:40.320><c> uh</c>

00:01:40.510 --> 00:01:40.520 align:start position:0%
I'm working on is called Alat tress uh
 

00:01:40.520 --> 00:01:44.670 align:start position:0%
I'm working on is called Alat tress uh
this<00:01:40.680><c> one</c><00:01:41.640><c> uh</c><00:01:42.399><c> we</c><00:01:43.399><c> we</c><00:01:43.600><c> have</c><00:01:43.920><c> some</c><00:01:44.240><c> special</c>

00:01:44.670 --> 00:01:44.680 align:start position:0%
this one uh we we have some special
 

00:01:44.680 --> 00:01:48.069 align:start position:0%
this one uh we we have some special
requirements<00:01:45.520><c> uh</c><00:01:45.640><c> we</c><00:01:45.759><c> want</c><00:01:45.960><c> to</c><00:01:46.719><c> index</c><00:01:47.320><c> like</c><00:01:47.840><c> uh</c>

00:01:48.069 --> 00:01:48.079 align:start position:0%
requirements uh we want to index like uh
 

00:01:48.079 --> 00:01:51.950 align:start position:0%
requirements uh we want to index like uh
all<00:01:48.759><c> address</c><00:01:49.759><c> in</c><00:01:50.000><c> on</c><00:01:50.200><c> the</c><00:01:50.360><c> ethereum</c><00:01:51.119><c> since</c>

00:01:51.950 --> 00:01:51.960 align:start position:0%
all address in on the ethereum since
 

00:01:51.960 --> 00:01:55.270 align:start position:0%
all address in on the ethereum since
Genesis<00:01:52.960><c> and</c><00:01:53.320><c> also</c><00:01:53.640><c> we</c><00:01:53.920><c> we</c><00:01:54.040><c> want</c><00:01:54.200><c> to</c><00:01:54.640><c> get</c><00:01:55.000><c> all</c>

00:01:55.270 --> 00:01:55.280 align:start position:0%
Genesis and also we we want to get all
 

00:01:55.280 --> 00:01:58.830 align:start position:0%
Genesis and also we we want to get all
the<00:01:55.920><c> erc20</c><00:01:56.880><c> token</c><00:01:57.360><c> events</c><00:01:58.240><c> and</c><00:01:58.399><c> then</c><00:01:58.640><c> get</c>

00:01:58.830 --> 00:01:58.840 align:start position:0%
the erc20 token events and then get
 

00:01:58.840 --> 00:02:01.789 align:start position:0%
the erc20 token events and then get
those<00:01:59.119><c> prices</c><00:02:00.119><c> to</c><00:02:00.360><c> get</c><00:02:00.640><c> the</c><00:02:01.079><c> what</c><00:02:01.479><c> uh</c><00:02:01.640><c> is</c>

00:02:01.789 --> 00:02:01.799 align:start position:0%
those prices to get the what uh is
 

00:02:01.799 --> 00:02:05.029 align:start position:0%
those prices to get the what uh is
called<00:02:02.039><c> p&amp;l</c><00:02:02.560><c> the</c><00:02:02.719><c> profit</c><00:02:03.000><c> and</c><00:02:03.200><c> loss</c><00:02:04.000><c> that's</c><00:02:04.439><c> uh</c>

00:02:05.029 --> 00:02:05.039 align:start position:0%
called p&amp;l the profit and loss that's uh
 

00:02:05.039 --> 00:02:08.510 align:start position:0%
called p&amp;l the profit and loss that's uh
that's<00:02:05.200><c> what</c><00:02:05.360><c> we</c><00:02:05.719><c> want</c><00:02:06.719><c> but</c><00:02:06.920><c> how</c><00:02:07.119><c> we</c><00:02:07.280><c> do</c><00:02:07.439><c> it</c><00:02:08.319><c> we</c>

00:02:08.510 --> 00:02:08.520 align:start position:0%
that's what we want but how we do it we
 

00:02:08.520 --> 00:02:11.029 align:start position:0%
that's what we want but how we do it we
cannot<00:02:08.840><c> do</c><00:02:09.039><c> it</c><00:02:09.560><c> in</c><00:02:09.720><c> in</c><00:02:09.840><c> a</c><00:02:10.080><c> conventional</c><00:02:10.720><c> way</c>

00:02:11.029 --> 00:02:11.039 align:start position:0%
cannot do it in in a conventional way
 

00:02:11.039 --> 00:02:13.949 align:start position:0%
cannot do it in in a conventional way
because<00:02:11.640><c> it</c><00:02:11.760><c> would</c><00:02:11.959><c> take</c><00:02:12.160><c> forever</c><00:02:12.840><c> right</c><00:02:13.760><c> uh</c>

00:02:13.949 --> 00:02:13.959 align:start position:0%
because it would take forever right uh
 

00:02:13.959 --> 00:02:17.790 align:start position:0%
because it would take forever right uh
to<00:02:14.560><c> to</c><00:02:14.720><c> read</c><00:02:15.319><c> uh</c><00:02:15.519><c> those</c><00:02:16.280><c> uh</c><00:02:16.800><c> 2.4</c><00:02:17.400><c> billion</c>

00:02:17.790 --> 00:02:17.800 align:start position:0%
to to read uh those uh 2.4 billion
 

00:02:17.800 --> 00:02:22.150 align:start position:0%
to to read uh those uh 2.4 billion
transactions<00:02:18.599><c> and</c><00:02:18.800><c> then</c><00:02:19.200><c> uh</c><00:02:19.360><c> loop</c><00:02:20.239><c> uh</c><00:02:20.400><c> one</c><00:02:20.599><c> by</c>

00:02:22.150 --> 00:02:22.160 align:start position:0%
transactions and then uh loop uh one by
 

00:02:22.160 --> 00:02:24.190 align:start position:0%
transactions and then uh loop uh one by
one

00:02:24.190 --> 00:02:24.200 align:start position:0%
one
 

00:02:24.200 --> 00:02:27.309 align:start position:0%
one
so<00:02:25.200><c> we</c><00:02:25.360><c> need</c><00:02:25.519><c> to</c>

00:02:27.309 --> 00:02:27.319 align:start position:0%
so we need to
 

00:02:27.319 --> 00:02:31.229 align:start position:0%
so we need to
uh<00:02:28.319><c> think</c><00:02:28.720><c> come</c><00:02:28.920><c> up</c><00:02:29.080><c> with</c><00:02:29.200><c> the</c><00:02:29.360><c> way</c><00:02:29.720><c> uh</c><00:02:30.160><c> to</c><00:02:31.000><c> do</c>

00:02:31.229 --> 00:02:31.239 align:start position:0%
uh think come up with the way uh to do
 

00:02:31.239 --> 00:02:34.470 align:start position:0%
uh think come up with the way uh to do
the<00:02:31.360><c> indexer</c><00:02:31.800><c> in</c><00:02:31.959><c> large</c><00:02:32.640><c> scale</c><00:02:33.640><c> so</c><00:02:34.120><c> let's</c><00:02:34.319><c> get</c>

00:02:34.470 --> 00:02:34.480 align:start position:0%
the indexer in large scale so let's get
 

00:02:34.480 --> 00:02:36.470 align:start position:0%
the indexer in large scale so let's get
back<00:02:34.640><c> to</c><00:02:34.760><c> the</c><00:02:34.920><c> basic</c><00:02:35.319><c> of</c><00:02:35.560><c> the</c><00:02:35.920><c> blockchain</c>

00:02:36.470 --> 00:02:36.480 align:start position:0%
back to the basic of the blockchain
 

00:02:36.480 --> 00:02:39.869 align:start position:0%
back to the basic of the blockchain
indexer<00:02:37.480><c> actually</c><00:02:37.920><c> it's</c><00:02:38.200><c> just</c><00:02:38.720><c> uh</c><00:02:39.519><c> data</c>

00:02:39.869 --> 00:02:39.879 align:start position:0%
indexer actually it's just uh data
 

00:02:39.879 --> 00:02:42.910 align:start position:0%
indexer actually it's just uh data
processing<00:02:40.519><c> right</c><00:02:41.280><c> we've</c><00:02:41.519><c> got</c><00:02:41.959><c> uh</c><00:02:42.159><c> input</c>

00:02:42.910 --> 00:02:42.920 align:start position:0%
processing right we've got uh input
 

00:02:42.920 --> 00:02:45.270 align:start position:0%
processing right we've got uh input
we've<00:02:43.200><c> got</c><00:02:43.840><c> uh</c><00:02:44.239><c> then</c><00:02:44.400><c> we</c><00:02:44.560><c> put</c><00:02:44.720><c> it</c><00:02:44.840><c> into</c><00:02:45.080><c> the</c>

00:02:45.270 --> 00:02:45.280 align:start position:0%
we've got uh then we put it into the
 

00:02:45.280 --> 00:02:47.710 align:start position:0%
we've got uh then we put it into the
process<00:02:45.920><c> and</c><00:02:46.120><c> then</c><00:02:46.480><c> we've</c><00:02:46.760><c> got</c>

00:02:47.710 --> 00:02:47.720 align:start position:0%
process and then we've got
 

00:02:47.720 --> 00:02:52.390 align:start position:0%
process and then we've got
output<00:02:48.720><c> yeah</c><00:02:49.200><c> so</c><00:02:49.519><c> let's</c><00:02:50.000><c> look</c><00:02:50.200><c> into</c><00:02:50.480><c> each</c>

00:02:52.390 --> 00:02:52.400 align:start position:0%
output yeah so let's look into each
 

00:02:52.400 --> 00:02:54.949 align:start position:0%
output yeah so let's look into each
component<00:02:53.400><c> what</c><00:02:53.519><c> we</c><00:02:53.640><c> need</c><00:02:53.920><c> from</c><00:02:54.080><c> the</c><00:02:54.280><c> input</c><00:02:54.720><c> to</c>

00:02:54.949 --> 00:02:54.959 align:start position:0%
component what we need from the input to
 

00:02:54.959 --> 00:02:58.750 align:start position:0%
component what we need from the input to
be<00:02:55.720><c> uh</c><00:02:56.400><c> able</c><00:02:56.680><c> to</c><00:02:56.920><c> process</c><00:02:57.360><c> it</c><00:02:57.879><c> uh</c><00:02:58.120><c> in</c><00:02:58.360><c> at</c><00:02:58.519><c> Large</c>

00:02:58.750 --> 00:02:58.760 align:start position:0%
be uh able to process it uh in at Large
 

00:02:58.760 --> 00:03:01.990 align:start position:0%
be uh able to process it uh in at Large
Scale<00:02:59.080><c> is</c><00:02:59.280><c> that</c><00:02:59.840><c> we</c><00:03:00.000><c> want</c><00:03:00.440><c> it</c><00:03:00.560><c> to</c><00:03:00.720><c> be</c><00:03:01.040><c> Compact</c>

00:03:01.990 --> 00:03:02.000 align:start position:0%
Scale is that we want it to be Compact
 

00:03:02.000 --> 00:03:03.390 align:start position:0%
Scale is that we want it to be Compact
and

00:03:03.390 --> 00:03:03.400 align:start position:0%
and
 

00:03:03.400 --> 00:03:05.789 align:start position:0%
and
structured<00:03:04.400><c> so</c><00:03:04.680><c> this</c><00:03:04.840><c> is</c><00:03:05.040><c> the</c><00:03:05.239><c> solution</c>

00:03:05.789 --> 00:03:05.799 align:start position:0%
structured so this is the solution
 

00:03:05.799 --> 00:03:09.630 align:start position:0%
structured so this is the solution
because<00:03:06.200><c> uh</c><00:03:06.400><c> pet</c><00:03:06.920><c> give</c><00:03:07.200><c> us</c><00:03:07.720><c> like</c><00:03:08.720><c> uh</c><00:03:09.080><c> the</c>

00:03:09.630 --> 00:03:09.640 align:start position:0%
because uh pet give us like uh the
 

00:03:09.640 --> 00:03:12.270 align:start position:0%
because uh pet give us like uh the
compression<00:03:10.640><c> uh</c><00:03:10.799><c> also</c><00:03:11.080><c> we</c><00:03:11.239><c> have</c><00:03:11.519><c> type</c><00:03:12.040><c> in</c>

00:03:12.270 --> 00:03:12.280 align:start position:0%
compression uh also we have type in
 

00:03:12.280 --> 00:03:16.149 align:start position:0%
compression uh also we have type in
pcket<00:03:12.560><c> as</c><00:03:12.680><c> well</c><00:03:12.959><c> c</c><00:03:13.280><c> c</c><00:03:13.680><c> pet</c><00:03:14.280><c> format</c><00:03:14.720><c> is</c><00:03:14.959><c> like</c><00:03:15.440><c> um</c>

00:03:16.149 --> 00:03:16.159 align:start position:0%
pcket as well c c pet format is like um
 

00:03:16.159 --> 00:03:19.670 align:start position:0%
pcket as well c c pet format is like um
CSV<00:03:16.879><c> but</c><00:03:17.120><c> better</c>

00:03:19.670 --> 00:03:19.680 align:start position:0%
 
 

00:03:19.680 --> 00:03:22.270 align:start position:0%
 
CSV<00:03:20.680><c> and</c><00:03:20.840><c> we</c><00:03:20.959><c> found</c><00:03:21.280><c> this</c><00:03:21.480><c> project</c><00:03:21.879><c> this</c><00:03:22.000><c> is</c><00:03:22.120><c> a</c>

00:03:22.270 --> 00:03:22.280 align:start position:0%
CSV and we found this project this is a
 

00:03:22.280 --> 00:03:25.910 align:start position:0%
CSV and we found this project this is a
very<00:03:22.440><c> good</c><00:03:22.599><c> open</c><00:03:22.840><c> source</c><00:03:23.599><c> project</c><00:03:24.599><c> uh</c><00:03:25.080><c> it</c><00:03:25.280><c> read</c>

00:03:25.910 --> 00:03:25.920 align:start position:0%
very good open source project uh it read
 

00:03:25.920 --> 00:03:28.190 align:start position:0%
very good open source project uh it read
data<00:03:26.239><c> on</c><00:03:26.400><c> the</c><00:03:26.560><c> ethereum</c><00:03:27.000><c> Node</c><00:03:27.360><c> and</c><00:03:27.519><c> then</c><00:03:27.840><c> write</c>

00:03:28.190 --> 00:03:28.200 align:start position:0%
data on the ethereum Node and then write
 

00:03:28.200 --> 00:03:31.470 align:start position:0%
data on the ethereum Node and then write
it<00:03:28.360><c> into</c><00:03:28.720><c> pocket</c><00:03:29.080><c> file</c><00:03:29.959><c> so</c><00:03:30.239><c> that</c><00:03:30.799><c> uh</c><00:03:31.080><c> when</c><00:03:31.319><c> we</c>

00:03:31.470 --> 00:03:31.480 align:start position:0%
it into pocket file so that uh when we
 

00:03:31.480 --> 00:03:33.869 align:start position:0%
it into pocket file so that uh when we
want<00:03:31.599><c> to</c><00:03:31.840><c> process</c><00:03:32.239><c> we</c><00:03:32.439><c> just</c><00:03:32.840><c> uh</c><00:03:33.000><c> read</c><00:03:33.519><c> uh</c><00:03:33.680><c> the</c>

00:03:33.869 --> 00:03:33.879 align:start position:0%
want to process we just uh read uh the
 

00:03:33.879 --> 00:03:36.390 align:start position:0%
want to process we just uh read uh the
file<00:03:34.439><c> in</c><00:03:34.640><c> in</c><00:03:34.760><c> our</c><00:03:35.000><c> file</c><00:03:35.280><c> system</c><00:03:36.000><c> that's</c><00:03:36.200><c> is</c>

00:03:36.390 --> 00:03:36.400 align:start position:0%
file in in our file system that's is
 

00:03:36.400 --> 00:03:38.670 align:start position:0%
file in in our file system that's is
very<00:03:36.720><c> lightweight</c><00:03:37.439><c> we</c><00:03:37.599><c> we</c><00:03:37.760><c> don't</c><00:03:37.920><c> need</c><00:03:38.080><c> to</c><00:03:38.560><c> uh</c>

00:03:38.670 --> 00:03:38.680 align:start position:0%
very lightweight we we don't need to uh
 

00:03:38.680 --> 00:03:42.550 align:start position:0%
very lightweight we we don't need to uh
call<00:03:39.080><c> the</c><00:03:39.560><c> node</c><00:03:39.959><c> every</c><00:03:40.200><c> time</c><00:03:40.640><c> to</c><00:03:40.840><c> get</c><00:03:41.000><c> the</c>

00:03:42.550 --> 00:03:42.560 align:start position:0%
call the node every time to get the
 

00:03:42.560 --> 00:03:46.589 align:start position:0%
call the node every time to get the
data<00:03:43.560><c> okay</c><00:03:44.159><c> let's</c><00:03:44.599><c> talk</c><00:03:44.840><c> about</c><00:03:45.040><c> the</c><00:03:45.599><c> process</c>

00:03:46.589 --> 00:03:46.599 align:start position:0%
data okay let's talk about the process
 

00:03:46.599 --> 00:03:49.589 align:start position:0%
data okay let's talk about the process
how<00:03:46.760><c> to</c><00:03:47.040><c> do</c><00:03:47.560><c> how</c><00:03:47.680><c> to</c><00:03:47.920><c> do</c><00:03:48.159><c> the</c><00:03:48.400><c> process</c><00:03:48.840><c> in</c><00:03:49.280><c> large</c>

00:03:49.589 --> 00:03:49.599 align:start position:0%
how to do how to do the process in large
 

00:03:49.599 --> 00:03:51.350 align:start position:0%
how to do how to do the process in large
scale

00:03:51.350 --> 00:03:51.360 align:start position:0%
scale
 

00:03:51.360 --> 00:03:55.550 align:start position:0%
scale
so<00:03:52.360><c> we</c><00:03:52.519><c> have</c><00:03:52.640><c> to</c><00:03:52.799><c> do</c><00:03:53.000><c> it</c><00:03:53.200><c> in</c><00:03:53.680><c> uh</c><00:03:54.200><c> in</c><00:03:54.360><c> a</c><00:03:54.879><c> parallel</c>

00:03:55.550 --> 00:03:55.560 align:start position:0%
so we have to do it in uh in a parallel
 

00:03:55.560 --> 00:04:00.030 align:start position:0%
so we have to do it in uh in a parallel
way<00:03:56.560><c> right</c><00:03:57.560><c> there</c><00:03:57.680><c> are</c><00:03:58.200><c> couples</c><00:03:58.720><c> of</c><00:03:59.319><c> uh</c>

00:04:00.030 --> 00:04:00.040 align:start position:0%
way right there are couples of uh
 

00:04:00.040 --> 00:04:02.869 align:start position:0%
way right there are couples of uh
solution<00:04:01.040><c> one</c><00:04:01.239><c> is</c><00:04:01.400><c> the</c><00:04:01.560><c> Apache</c><00:04:02.040><c> spark</c><00:04:02.560><c> another</c>

00:04:02.869 --> 00:04:02.879 align:start position:0%
solution one is the Apache spark another
 

00:04:02.879 --> 00:04:06.750 align:start position:0%
solution one is the Apache spark another
is<00:04:03.040><c> Apache</c><00:04:03.920><c> beam</c><00:04:04.920><c> uh</c><00:04:05.280><c> we</c><00:04:05.400><c> choose</c><00:04:06.040><c> Apache</c><00:04:06.439><c> beam</c>

00:04:06.750 --> 00:04:06.760 align:start position:0%
is Apache beam uh we choose Apache beam
 

00:04:06.760 --> 00:04:08.869 align:start position:0%
is Apache beam uh we choose Apache beam
because<00:04:07.200><c> there</c><00:04:07.280><c> is</c><00:04:07.360><c> a</c><00:04:07.480><c> Min</c><00:04:07.920><c> service</c><00:04:08.280><c> on</c><00:04:08.439><c> the</c>

00:04:08.869 --> 00:04:08.879 align:start position:0%
because there is a Min service on the
 

00:04:08.879 --> 00:04:11.309 align:start position:0%
because there is a Min service on the
cloud

00:04:11.309 --> 00:04:11.319 align:start position:0%
 
 

00:04:11.319 --> 00:04:13.229 align:start position:0%
 
platform<00:04:12.319><c> and</c><00:04:12.439><c> then</c>

00:04:13.229 --> 00:04:13.239 align:start position:0%
platform and then
 

00:04:13.239 --> 00:04:16.870 align:start position:0%
platform and then
output<00:04:14.239><c> when</c><00:04:14.560><c> we</c><00:04:14.799><c> have</c><00:04:15.079><c> process</c><00:04:15.480><c> the</c><00:04:15.759><c> data</c><00:04:16.759><c> we</c>

00:04:16.870 --> 00:04:16.880 align:start position:0%
output when we have process the data we
 

00:04:16.880 --> 00:04:20.789 align:start position:0%
output when we have process the data we
have<00:04:17.000><c> to</c><00:04:17.160><c> write</c><00:04:17.359><c> it</c><00:04:17.519><c> somewhere</c><00:04:18.239><c> right</c><00:04:19.239><c> so</c>

00:04:20.789 --> 00:04:20.799 align:start position:0%
have to write it somewhere right so
 

00:04:20.799 --> 00:04:25.270 align:start position:0%
have to write it somewhere right so
uh<00:04:21.799><c> that</c><00:04:22.479><c> that</c><00:04:23.280><c> uh</c><00:04:24.120><c> destination</c><00:04:24.880><c> that</c><00:04:25.040><c> I</c><00:04:25.160><c> have</c>

00:04:25.270 --> 00:04:25.280 align:start position:0%
uh that that uh destination that I have
 

00:04:25.280 --> 00:04:28.510 align:start position:0%
uh that that uh destination that I have
to<00:04:25.479><c> write</c><00:04:26.120><c> uh</c><00:04:26.280><c> need</c><00:04:26.520><c> to</c><00:04:26.919><c> be</c><00:04:27.080><c> able</c><00:04:27.360><c> to</c><00:04:27.600><c> scale</c>

00:04:28.510 --> 00:04:28.520 align:start position:0%
to write uh need to be able to scale
 

00:04:28.520 --> 00:04:31.550 align:start position:0%
to write uh need to be able to scale
horizontally<00:04:29.520><c> me</c><00:04:29.720><c> meaning</c><00:04:30.080><c> that</c><00:04:30.720><c> uh</c><00:04:31.280><c> if</c><00:04:31.440><c> I</c>

00:04:31.550 --> 00:04:31.560 align:start position:0%
horizontally me meaning that uh if I
 

00:04:31.560 --> 00:04:34.070 align:start position:0%
horizontally me meaning that uh if I
want<00:04:31.720><c> to</c><00:04:31.880><c> read</c><00:04:32.240><c> a</c><00:04:32.360><c> lot</c><00:04:32.560><c> of</c><00:04:33.000><c> and</c><00:04:33.160><c> write</c><00:04:33.360><c> a</c><00:04:33.520><c> lot</c><00:04:33.680><c> of</c>

00:04:34.070 --> 00:04:34.080 align:start position:0%
want to read a lot of and write a lot of
 

00:04:34.080 --> 00:04:37.430 align:start position:0%
want to read a lot of and write a lot of
data<00:04:35.080><c> I</c><00:04:35.199><c> can</c><00:04:35.479><c> just</c><00:04:36.000><c> uh</c><00:04:36.199><c> create</c><00:04:36.560><c> new</c><00:04:36.800><c> instances</c>

00:04:37.430 --> 00:04:37.440 align:start position:0%
data I can just uh create new instances
 

00:04:37.440 --> 00:04:41.830 align:start position:0%
data I can just uh create new instances
and<00:04:37.680><c> then</c><00:04:38.680><c> uh</c><00:04:39.199><c> I</c><00:04:39.320><c> can</c><00:04:39.720><c> read</c><00:04:39.919><c> and</c><00:04:40.160><c> write</c><00:04:40.639><c> uh</c>

00:04:41.830 --> 00:04:41.840 align:start position:0%
and then uh I can read and write uh
 

00:04:41.840 --> 00:04:44.870 align:start position:0%
and then uh I can read and write uh
more<00:04:42.840><c> there</c><00:04:42.960><c> are</c><00:04:43.120><c> a</c><00:04:43.240><c> couple</c><00:04:43.560><c> of</c><00:04:43.880><c> solution</c><00:04:44.479><c> to</c>

00:04:44.870 --> 00:04:44.880 align:start position:0%
more there are a couple of solution to
 

00:04:44.880 --> 00:04:49.830 align:start position:0%
more there are a couple of solution to
do<00:04:45.320><c> the</c><00:04:46.320><c> uh</c><00:04:46.479><c> distributed</c><00:04:47.160><c> dat</c><00:04:47.440><c> database</c><00:04:48.639><c> uh</c><00:04:49.639><c> as</c>

00:04:49.830 --> 00:04:49.840 align:start position:0%
do the uh distributed dat database uh as
 

00:04:49.840 --> 00:04:52.790 align:start position:0%
do the uh distributed dat database uh as
you<00:04:50.600><c> might</c><00:04:50.880><c> guess</c><00:04:51.160><c> that</c><00:04:51.600><c> I</c><00:04:51.919><c> selected</c><00:04:52.560><c> the</c>

00:04:52.790 --> 00:04:52.800 align:start position:0%
you might guess that I selected the
 

00:04:52.800 --> 00:04:54.550 align:start position:0%
you might guess that I selected the
Google<00:04:53.120><c> big</c><00:04:53.320><c> table</c><00:04:53.720><c> because</c><00:04:53.960><c> I</c><00:04:54.039><c> don't</c><00:04:54.240><c> have</c><00:04:54.360><c> to</c>

00:04:54.550 --> 00:04:54.560 align:start position:0%
Google big table because I don't have to
 

00:04:54.560 --> 00:04:56.870 align:start position:0%
Google big table because I don't have to
worry<00:04:55.039><c> anything</c><00:04:55.400><c> about</c><00:04:56.000><c> infrastructure</c><00:04:56.720><c> of</c>

00:04:56.870 --> 00:04:56.880 align:start position:0%
worry anything about infrastructure of
 

00:04:56.880 --> 00:04:59.790 align:start position:0%
worry anything about infrastructure of
the<00:04:57.080><c> database</c>

00:04:59.790 --> 00:04:59.800 align:start position:0%
the database
 

00:04:59.800 --> 00:05:03.550 align:start position:0%
the database
all<00:04:59.960><c> right</c><00:05:00.560><c> now</c><00:05:01.160><c> piece</c><00:05:01.560><c> everything</c><00:05:02.560><c> together</c>

00:05:03.550 --> 00:05:03.560 align:start position:0%
all right now piece everything together
 

00:05:03.560 --> 00:05:05.350 align:start position:0%
all right now piece everything together
and<00:05:04.400><c> do</c><00:05:04.639><c> some</c>

00:05:05.350 --> 00:05:05.360 align:start position:0%
and do some
 

00:05:05.360 --> 00:05:09.270 align:start position:0%
and do some
coding<00:05:06.360><c> this</c><00:05:06.880><c> this</c><00:05:07.240><c> uh</c><00:05:07.360><c> does</c><00:05:07.520><c> not</c><00:05:07.800><c> take</c><00:05:08.560><c> uh</c><00:05:09.000><c> 10</c>

00:05:09.270 --> 00:05:09.280 align:start position:0%
coding this this uh does not take uh 10
 

00:05:09.280 --> 00:05:12.950 align:start position:0%
coding this this uh does not take uh 10
hours<00:05:10.039><c> in</c><00:05:10.479><c> i</c><00:05:10.680><c> i</c><00:05:10.840><c> in</c><00:05:11.039><c> the</c><00:05:11.199><c> coding</c><00:05:12.039><c> uh</c><00:05:12.160><c> it</c><00:05:12.320><c> took</c><00:05:12.520><c> me</c>

00:05:12.950 --> 00:05:12.960 align:start position:0%
hours in i i in the coding uh it took me
 

00:05:12.960 --> 00:05:16.830 align:start position:0%
hours in i i in the coding uh it took me
like<00:05:13.960><c> uh</c><00:05:14.240><c> two</c><00:05:14.560><c> three</c><00:05:14.800><c> weeks</c><00:05:15.360><c> uh</c><00:05:15.479><c> to</c><00:05:15.720><c> work</c><00:05:15.960><c> on</c>

00:05:16.830 --> 00:05:16.840 align:start position:0%
like uh two three weeks uh to work on
 

00:05:16.840 --> 00:05:19.110 align:start position:0%
like uh two three weeks uh to work on
all<00:05:17.000><c> the</c><00:05:17.199><c> components</c><00:05:17.960><c> and</c><00:05:18.479><c> understand</c><00:05:18.720><c> how</c>

00:05:19.110 --> 00:05:19.120 align:start position:0%
all the components and understand how
 

00:05:19.120 --> 00:05:24.590 align:start position:0%
all the components and understand how
Apache<00:05:19.560><c> beam</c><00:05:19.840><c> works</c><00:05:20.639><c> and</c><00:05:20.840><c> actually</c><00:05:21.199><c> write</c>

00:05:24.590 --> 00:05:24.600 align:start position:0%
 
 

00:05:24.600 --> 00:05:28.189 align:start position:0%
 
it<00:05:25.600><c> uh</c><00:05:26.560><c> this</c><00:05:26.680><c> is</c><00:05:26.960><c> uh</c><00:05:27.080><c> what</c><00:05:27.240><c> the</c><00:05:27.440><c> final</c><00:05:27.800><c> pipeline</c>

00:05:28.189 --> 00:05:28.199 align:start position:0%
it uh this is uh what the final pipeline
 

00:05:28.199 --> 00:05:30.830 align:start position:0%
it uh this is uh what the final pipeline
looks<00:05:28.479><c> like</c><00:05:28.840><c> so</c><00:05:29.199><c> data</c><00:05:29.720><c> comes</c><00:05:30.199><c> from</c><00:05:30.400><c> the</c><00:05:30.600><c> top</c>

00:05:30.830 --> 00:05:30.840 align:start position:0%
looks like so data comes from the top
 

00:05:30.840 --> 00:05:33.510 align:start position:0%
looks like so data comes from the top
and<00:05:31.000><c> then</c><00:05:31.479><c> uh</c><00:05:31.840><c> trickle</c><00:05:32.280><c> down</c><00:05:32.759><c> and</c><00:05:32.919><c> then</c><00:05:33.199><c> uh</c><00:05:33.319><c> get</c>

00:05:33.510 --> 00:05:33.520 align:start position:0%
and then uh trickle down and then uh get
 

00:05:33.520 --> 00:05:35.710 align:start position:0%
and then uh trickle down and then uh get
the

00:05:35.710 --> 00:05:35.720 align:start position:0%
the
 

00:05:35.720 --> 00:05:40.350 align:start position:0%
the
result<00:05:36.720><c> and</c><00:05:36.960><c> we</c><00:05:37.520><c> wait</c><00:05:38.520><c> around</c><00:05:39.000><c> 10</c>

00:05:40.350 --> 00:05:40.360 align:start position:0%
result and we wait around 10
 

00:05:40.360 --> 00:05:45.510 align:start position:0%
result and we wait around 10
hours<00:05:41.360><c> and</c><00:05:41.520><c> it</c><00:05:41.720><c> finish</c><00:05:42.400><c> just</c><00:05:42.639><c> like</c><00:05:42.880><c> that</c><00:05:43.840><c> yeah</c>

00:05:45.510 --> 00:05:45.520 align:start position:0%
hours and it finish just like that yeah
 

00:05:45.520 --> 00:05:51.990 align:start position:0%
hours and it finish just like that yeah
um<00:05:46.520><c> so</c><00:05:47.440><c> we</c><00:05:47.880><c> I</c><00:05:48.400><c> I</c><00:05:49.120><c> I</c><00:05:49.960><c> uh</c><00:05:50.680><c> ran</c><00:05:50.960><c> it</c><00:05:51.240><c> and</c><00:05:51.440><c> it</c><00:05:51.600><c> took</c>

00:05:51.990 --> 00:05:52.000 align:start position:0%
um so we I I I uh ran it and it took
 

00:05:52.000 --> 00:05:54.749 align:start position:0%
um so we I I I uh ran it and it took
like<00:05:52.240><c> around</c><00:05:52.560><c> 10</c><00:05:52.840><c> hours</c><00:05:53.280><c> to</c><00:05:53.680><c> index</c><00:05:54.160><c> all</c><00:05:54.479><c> the</c>

00:05:54.749 --> 00:05:54.759 align:start position:0%
like around 10 hours to index all the
 

00:05:54.759 --> 00:05:58.029 align:start position:0%
like around 10 hours to index all the
ethereum<00:05:55.319><c> transaction</c><00:05:56.319><c> all</c><00:05:56.639><c> the</c><00:05:57.080><c> uh</c><00:05:57.199><c> erc20</c>

00:05:58.029 --> 00:05:58.039 align:start position:0%
ethereum transaction all the uh erc20
 

00:05:58.039 --> 00:06:00.150 align:start position:0%
ethereum transaction all the uh erc20
token<00:05:58.319><c> transfers</c>

00:06:00.150 --> 00:06:00.160 align:start position:0%
token transfers
 

00:06:00.160 --> 00:06:02.510 align:start position:0%
token transfers
and<00:06:00.680><c> there's</c><00:06:00.919><c> something</c><00:06:01.280><c> more</c><00:06:01.520><c> on</c><00:06:01.720><c> it</c><00:06:02.039><c> because</c>

00:06:02.510 --> 00:06:02.520 align:start position:0%
and there's something more on it because
 

00:06:02.520 --> 00:06:05.830 align:start position:0%
and there's something more on it because
we<00:06:02.840><c> only</c><00:06:03.199><c> index</c><00:06:04.000><c> uh</c><00:06:04.520><c> the</c><00:06:04.720><c> current</c><00:06:05.160><c> data</c><00:06:05.680><c> right</c>

00:06:05.830 --> 00:06:05.840 align:start position:0%
we only index uh the current data right
 

00:06:05.840 --> 00:06:09.070 align:start position:0%
we only index uh the current data right
the<00:06:06.080><c> big</c><00:06:06.400><c> bat</c><00:06:06.880><c> very</c><00:06:07.160><c> very</c><00:06:07.360><c> big</c><00:06:07.639><c> batch</c><00:06:07.960><c> of</c><00:06:08.160><c> data</c>

00:06:09.070 --> 00:06:09.080 align:start position:0%
the big bat very very big batch of data
 

00:06:09.080 --> 00:06:12.589 align:start position:0%
the big bat very very big batch of data
and<00:06:09.199><c> how</c><00:06:09.319><c> to</c><00:06:09.479><c> make</c><00:06:09.599><c> it</c><00:06:09.759><c> real</c><00:06:10.080><c> time</c><00:06:11.080><c> so</c><00:06:11.759><c> uh</c><00:06:12.520><c> I</c>

00:06:12.589 --> 00:06:12.599 align:start position:0%
and how to make it real time so uh I
 

00:06:12.599 --> 00:06:15.350 align:start position:0%
and how to make it real time so uh I
need<00:06:12.759><c> to</c><00:06:12.919><c> do</c><00:06:13.120><c> it</c><00:06:13.440><c> in</c><00:06:13.560><c> a</c><00:06:13.759><c> conventional</c><00:06:14.400><c> way</c><00:06:15.160><c> uh</c>

00:06:15.350 --> 00:06:15.360 align:start position:0%
need to do it in a conventional way uh
 

00:06:15.360 --> 00:06:19.510 align:start position:0%
need to do it in a conventional way uh
to<00:06:16.360><c> to</c><00:06:17.039><c> uh</c><00:06:17.319><c> update</c><00:06:18.160><c> uh</c><00:06:18.319><c> to</c><00:06:18.479><c> get</c><00:06:18.680><c> the</c><00:06:18.840><c> new</c><00:06:19.400><c> uh</c>

00:06:19.510 --> 00:06:19.520 align:start position:0%
to to uh update uh to get the new uh
 

00:06:19.520 --> 00:06:21.589 align:start position:0%
to to uh update uh to get the new uh
blocks<00:06:20.160><c> and</c><00:06:20.319><c> then</c><00:06:20.599><c> because</c><00:06:20.960><c> I</c><00:06:21.080><c> I</c><00:06:21.160><c> don't</c><00:06:21.360><c> need</c>

00:06:21.589 --> 00:06:21.599 align:start position:0%
blocks and then because I I don't need
 

00:06:21.599 --> 00:06:23.589 align:start position:0%
blocks and then because I I don't need
it<00:06:21.720><c> to</c><00:06:21.919><c> do</c><00:06:22.080><c> at</c><00:06:22.280><c> last</c><00:06:22.479><c> scale</c><00:06:22.720><c> anymore</c><00:06:23.120><c> right</c><00:06:23.440><c> I</c>

00:06:23.589 --> 00:06:23.599 align:start position:0%
it to do at last scale anymore right I
 

00:06:23.599 --> 00:06:25.670 align:start position:0%
it to do at last scale anymore right I
can<00:06:23.800><c> just</c><00:06:24.000><c> do</c><00:06:24.160><c> it</c><00:06:24.560><c> a</c><00:06:24.720><c> traditional</c><00:06:25.280><c> way</c><00:06:25.400><c> to</c><00:06:25.560><c> make</c>

00:06:25.670 --> 00:06:25.680 align:start position:0%
can just do it a traditional way to make
 

00:06:25.680 --> 00:06:27.029 align:start position:0%
can just do it a traditional way to make
it<00:06:25.840><c> real</c>

00:06:27.029 --> 00:06:27.039 align:start position:0%
it real
 

00:06:27.039 --> 00:06:30.990 align:start position:0%
it real
time<00:06:28.039><c> these</c><00:06:28.199><c> are</c><00:06:28.360><c> the</c><00:06:28.520><c> numbers</c>

00:06:30.990 --> 00:06:31.000 align:start position:0%
time these are the numbers
 

00:06:31.000 --> 00:06:36.390 align:start position:0%
time these are the numbers
um<00:06:32.000><c> it</c><00:06:32.199><c> cost</c><00:06:32.440><c> me</c><00:06:32.960><c> about</c><00:06:33.720><c> uh</c>

00:06:36.390 --> 00:06:36.400 align:start position:0%
 
 

00:06:36.400 --> 00:06:39.629 align:start position:0%
 
$350<00:06:37.400><c> and</c><00:06:37.800><c> the</c><00:06:37.960><c> number</c><00:06:38.360><c> of</c><00:06:38.599><c> the</c><00:06:38.880><c> row</c><00:06:39.360><c> that</c><00:06:39.479><c> is</c>

00:06:39.629 --> 00:06:39.639 align:start position:0%
$350 and the number of the row that is
 

00:06:39.639 --> 00:06:42.629 align:start position:0%
$350 and the number of the row that is
written<00:06:40.039><c> on</c><00:06:40.240><c> the</c><00:06:40.400><c> database</c><00:06:40.919><c> in</c><00:06:41.080><c> 10</c><00:06:41.440><c> hours</c><00:06:42.440><c> uh</c>

00:06:42.629 --> 00:06:42.639 align:start position:0%
written on the database in 10 hours uh
 

00:06:42.639 --> 00:06:47.110 align:start position:0%
written on the database in 10 hours uh
was<00:06:43.039><c> the</c><00:06:43.479><c> uh</c><00:06:43.599><c> 7.1</c><00:06:44.280><c> billion</c><00:06:45.479><c> records</c><00:06:46.479><c> and</c><00:06:46.960><c> I</c>

00:06:47.110 --> 00:06:47.120 align:start position:0%
was the uh 7.1 billion records and I
 

00:06:47.120 --> 00:06:50.070 align:start position:0%
was the uh 7.1 billion records and I
scale<00:06:47.560><c> the</c><00:06:48.000><c> big</c><00:06:48.199><c> table</c><00:06:48.479><c> inance</c><00:06:49.080><c> up</c><00:06:49.240><c> to</c><00:06:49.479><c> 20</c>

00:06:50.070 --> 00:06:50.080 align:start position:0%
scale the big table inance up to 20
 

00:06:50.080 --> 00:06:52.150 align:start position:0%
scale the big table inance up to 20
incenses<00:06:51.080><c> the</c><00:06:51.199><c> good</c><00:06:51.360><c> thing</c><00:06:51.479><c> about</c><00:06:51.680><c> big</c><00:06:51.880><c> table</c>

00:06:52.150 --> 00:06:52.160 align:start position:0%
incenses the good thing about big table
 

00:06:52.160 --> 00:06:54.990 align:start position:0%
incenses the good thing about big table
is<00:06:52.319><c> that</c><00:06:52.639><c> when</c><00:06:52.919><c> I</c><00:06:53.120><c> finish</c><00:06:54.120><c> uh</c><00:06:54.240><c> writing</c><00:06:54.800><c> the</c>

00:06:54.990 --> 00:06:55.000 align:start position:0%
is that when I finish uh writing the
 

00:06:55.000 --> 00:06:58.550 align:start position:0%
is that when I finish uh writing the
data<00:06:55.720><c> I</c><00:06:55.840><c> can</c><00:06:56.000><c> scale</c><00:06:56.319><c> it</c><00:06:56.520><c> down</c><00:06:57.440><c> so</c><00:06:58.199><c> after</c><00:06:58.440><c> I</c>

00:06:58.550 --> 00:06:58.560 align:start position:0%
data I can scale it down so after I
 

00:06:58.560 --> 00:07:01.029 align:start position:0%
data I can scale it down so after I
finish<00:06:59.000><c> uh</c><00:06:59.160><c> index</c><00:06:59.680><c> those</c><00:06:59.919><c> big</c><00:07:00.160><c> data</c><00:07:00.479><c> I</c><00:07:00.680><c> scale</c>

00:07:01.029 --> 00:07:01.039 align:start position:0%
finish uh index those big data I scale
 

00:07:01.039 --> 00:07:04.869 align:start position:0%
finish uh index those big data I scale
out<00:07:01.160><c> to</c><00:07:01.360><c> just</c><00:07:01.560><c> one</c><00:07:01.919><c> to</c><00:07:02.199><c> handle</c><00:07:02.919><c> the</c><00:07:03.120><c> normal</c><00:07:03.919><c> we</c>

00:07:04.869 --> 00:07:04.879 align:start position:0%
out to just one to handle the normal we
 

00:07:04.879 --> 00:07:05.790 align:start position:0%
out to just one to handle the normal we
uh

00:07:05.790 --> 00:07:05.800 align:start position:0%
uh
 

00:07:05.800 --> 00:07:08.189 align:start position:0%
uh
operation<00:07:06.800><c> yeah</c><00:07:07.319><c> that's</c><00:07:07.560><c> that's</c><00:07:07.720><c> the</c><00:07:08.000><c> good</c>

00:07:08.189 --> 00:07:08.199 align:start position:0%
operation yeah that's that's the good
 

00:07:08.199 --> 00:07:10.830 align:start position:0%
operation yeah that's that's the good
thing<00:07:08.440><c> about</c><00:07:09.199><c> uh</c><00:07:09.840><c> this</c><00:07:10.039><c> whole</c>

00:07:10.830 --> 00:07:10.840 align:start position:0%
thing about uh this whole
 

00:07:10.840 --> 00:07:14.390 align:start position:0%
thing about uh this whole
thing<00:07:11.840><c> yep</c><00:07:12.160><c> I</c><00:07:12.280><c> think</c><00:07:12.960><c> uh</c><00:07:13.400><c> that's</c><00:07:13.639><c> all</c><00:07:14.000><c> for</c><00:07:14.199><c> me</c>

00:07:14.390 --> 00:07:14.400 align:start position:0%
thing yep I think uh that's all for me
 

00:07:14.400 --> 00:07:18.510 align:start position:0%
thing yep I think uh that's all for me
today<00:07:15.240><c> thank</c><00:07:15.440><c> you</c><00:07:15.759><c> very</c>

00:07:18.510 --> 00:07:18.520 align:start position:0%
 
 

00:07:18.520 --> 00:07:22.869 align:start position:0%
 
much<00:07:19.520><c> all</c><00:07:19.800><c> right</c><00:07:20.800><c> uh</c><00:07:21.039><c> so</c><00:07:21.560><c> we</c><00:07:21.919><c> can</c><00:07:22.360><c> ask</c><00:07:22.599><c> some</c>

00:07:22.869 --> 00:07:22.879 align:start position:0%
much all right uh so we can ask some
 

00:07:22.879 --> 00:07:25.670 align:start position:0%
much all right uh so we can ask some
questions<00:07:23.400><c> in</c><00:07:23.599><c> the</c><00:07:23.960><c> audience</c><00:07:24.960><c> uh</c><00:07:25.199><c> we</c><00:07:25.280><c> can</c><00:07:25.479><c> pass</c>

00:07:25.670 --> 00:07:25.680 align:start position:0%
questions in the audience uh we can pass
 

00:07:25.680 --> 00:07:27.189 align:start position:0%
questions in the audience uh we can pass
around<00:07:25.879><c> the</c><00:07:26.000><c> mic</c><00:07:26.280><c> if</c><00:07:26.400><c> there's</c><00:07:26.639><c> any</c><00:07:26.840><c> questions</c>

00:07:27.189 --> 00:07:27.199 align:start position:0%
around the mic if there's any questions
 

00:07:27.199 --> 00:07:30.790 align:start position:0%
around the mic if there's any questions
for<00:07:27.879><c> p</c><00:07:28.879><c> oh</c><00:07:29.120><c> we</c><00:07:29.240><c> do</c><00:07:29.560><c> oh</c><00:07:30.000><c> awesome</c><00:07:30.360><c> we</c><00:07:30.479><c> do</c><00:07:30.639><c> have</c>

00:07:30.790 --> 00:07:30.800 align:start position:0%
for p oh we do oh awesome we do have
 

00:07:30.800 --> 00:07:33.990 align:start position:0%
for p oh we do oh awesome we do have
some<00:07:31.039><c> questions</c><00:07:31.360><c> on</c><00:07:31.560><c> screen</c><00:07:32.319><c> so</c><00:07:33.319><c> let's</c><00:07:33.720><c> go</c>

00:07:33.990 --> 00:07:34.000 align:start position:0%
some questions on screen so let's go
 

00:07:34.000 --> 00:07:36.670 align:start position:0%
some questions on screen so let's go
through<00:07:34.720><c> the</c><00:07:34.879><c> first</c><00:07:35.120><c> one</c><00:07:35.479><c> for</c><00:07:35.759><c> eth</c><00:07:36.080><c> node</c><00:07:36.520><c> how</c>

00:07:36.670 --> 00:07:36.680 align:start position:0%
through the first one for eth node how
 

00:07:36.680 --> 00:07:39.469 align:start position:0%
through the first one for eth node how
did<00:07:36.840><c> you</c><00:07:37.000><c> host</c><00:07:37.280><c> that</c><00:07:37.520><c> to</c><00:07:37.759><c> handle</c><00:07:38.080><c> large</c><00:07:38.479><c> read</c>

00:07:39.469 --> 00:07:39.479 align:start position:0%
did you host that to handle large read
 

00:07:39.479 --> 00:07:42.309 align:start position:0%
did you host that to handle large read
all<00:07:39.680><c> right</c><00:07:40.479><c> um</c><00:07:40.759><c> for</c>

00:07:42.309 --> 00:07:42.319 align:start position:0%
all right um for
 

00:07:42.319 --> 00:07:47.510 align:start position:0%
all right um for
the<00:07:43.319><c> in</c><00:07:43.520><c> this</c><00:07:43.800><c> process</c><00:07:44.319><c> is</c><00:07:44.680><c> the</c><00:07:45.599><c> uh</c><00:07:46.599><c> is</c>

00:07:47.510 --> 00:07:47.520 align:start position:0%
the in this process is the uh is
 

00:07:47.520 --> 00:07:50.510 align:start position:0%
the in this process is the uh is
the<00:07:48.520><c> uh</c><00:07:48.759><c> cryo</c><00:07:49.360><c> right</c><00:07:49.520><c> cryo</c><00:07:49.960><c> reads</c><00:07:50.240><c> from</c><00:07:50.400><c> the</c>

00:07:50.510 --> 00:07:50.520 align:start position:0%
the uh cryo right cryo reads from the
 

00:07:50.520 --> 00:07:54.749 align:start position:0%
the uh cryo right cryo reads from the
node<00:07:51.280><c> not</c><00:07:51.759><c> not</c><00:07:52.039><c> our</c><00:07:52.319><c> not</c><00:07:52.440><c> my</c><00:07:52.599><c> indexer</c><00:07:53.199><c> right</c><00:07:53.759><c> so</c>

00:07:54.749 --> 00:07:54.759 align:start position:0%
node not not our not my indexer right so
 

00:07:54.759 --> 00:07:57.710 align:start position:0%
node not not our not my indexer right so
uh<00:07:55.400><c> we</c><00:07:55.560><c> use</c><00:07:55.759><c> Min</c><00:07:56.120><c> service</c><00:07:56.879><c> and</c><00:07:57.159><c> that</c><00:07:57.360><c> is</c><00:07:57.520><c> a</c>

00:07:57.710 --> 00:07:57.720 align:start position:0%
uh we use Min service and that is a
 

00:07:57.720 --> 00:08:00.909 align:start position:0%
uh we use Min service and that is a
dedicated<00:07:58.639><c> uh</c><00:07:58.840><c> server</c><00:07:59.199><c> to</c><00:07:59.560><c> to</c><00:07:59.840><c> all</c><00:07:59.960><c> the</c>

00:08:00.909 --> 00:08:00.919 align:start position:0%
dedicated uh server to to all the
 

00:08:00.919 --> 00:08:04.550 align:start position:0%
dedicated uh server to to all the
data<00:08:01.919><c> yeah</c><00:08:02.720><c> all</c><00:08:02.840><c> right</c><00:08:03.039><c> I</c><00:08:03.159><c> guess</c><00:08:03.360><c> we</c><00:08:03.639><c> have</c><00:08:04.360><c> one</c>

00:08:04.550 --> 00:08:04.560 align:start position:0%
data yeah all right I guess we have one
 

00:08:04.560 --> 00:08:07.110 align:start position:0%
data yeah all right I guess we have one
minute<00:08:04.800><c> to</c><00:08:05.000><c> take</c><00:08:05.199><c> one</c><00:08:05.400><c> more</c><00:08:05.879><c> question</c><00:08:06.879><c> uh</c>

00:08:07.110 --> 00:08:07.120 align:start position:0%
minute to take one more question uh
 

00:08:07.120 --> 00:08:09.430 align:start position:0%
minute to take one more question uh
where<00:08:07.280><c> are</c><00:08:07.479><c> you</c><00:08:07.639><c> reading</c><00:08:08.159><c> the</c><00:08:08.599><c> archive</c><00:08:09.120><c> data</c>

00:08:09.430 --> 00:08:09.440 align:start position:0%
where are you reading the archive data
 

00:08:09.440 --> 00:08:11.189 align:start position:0%
where are you reading the archive data
from<00:08:09.800><c> how</c><00:08:09.919><c> does</c><00:08:10.120><c> reading</c><00:08:10.560><c> from</c><00:08:10.759><c> the</c><00:08:10.879><c> node</c>

00:08:11.189 --> 00:08:11.199 align:start position:0%
from how does reading from the node
 

00:08:11.199 --> 00:08:14.230 align:start position:0%
from how does reading from the node
scale<00:08:11.560><c> for</c><00:08:11.879><c> you</c><00:08:12.879><c> okay</c><00:08:13.159><c> fortunate</c><00:08:13.759><c> fortunately</c>

00:08:14.230 --> 00:08:14.240 align:start position:0%
scale for you okay fortunate fortunately
 

00:08:14.240 --> 00:08:16.710 align:start position:0%
scale for you okay fortunate fortunately
for<00:08:14.520><c> my</c><00:08:14.960><c> for</c><00:08:15.199><c> my</c><00:08:15.840><c> case</c><00:08:16.080><c> I</c><00:08:16.159><c> don't</c><00:08:16.319><c> need</c><00:08:16.520><c> the</c>

00:08:16.710 --> 00:08:16.720 align:start position:0%
for my for my case I don't need the
 

00:08:16.720 --> 00:08:18.990 align:start position:0%
for my for my case I don't need the
archive<00:08:17.120><c> data</c><00:08:17.440><c> I</c><00:08:17.560><c> just</c><00:08:17.680><c> need</c><00:08:17.879><c> the</c><00:08:18.360><c> transaction</c>

00:08:18.990 --> 00:08:19.000 align:start position:0%
archive data I just need the transaction
 

00:08:19.000 --> 00:08:21.790 align:start position:0%
archive data I just need the transaction
data<00:08:19.400><c> the</c><00:08:19.759><c> locks</c><00:08:20.759><c> yeah</c><00:08:20.960><c> from</c><00:08:21.440><c> from</c><00:08:21.680><c> the</c>

00:08:21.790 --> 00:08:21.800 align:start position:0%
data the locks yeah from from the
 

00:08:21.800 --> 00:08:25.390 align:start position:0%
data the locks yeah from from the
ethereum<00:08:22.240><c> node</c><00:08:22.599><c> that</c><00:08:22.720><c> is</c><00:08:22.879><c> just</c><00:08:23.039><c> full</c><00:08:23.280><c> node</c><00:08:23.560><c> is</c>

00:08:25.390 --> 00:08:25.400 align:start position:0%
ethereum node that is just full node is
 

00:08:25.400 --> 00:08:28.469 align:start position:0%
ethereum node that is just full node is
suffice<00:08:26.400><c> all</c><00:08:26.599><c> right</c><00:08:27.360><c> um</c><00:08:27.560><c> so</c><00:08:27.759><c> I</c><00:08:27.879><c> think</c><00:08:28.280><c> that</c>

00:08:28.469 --> 00:08:28.479 align:start position:0%
suffice all right um so I think that
 

00:08:28.479 --> 00:08:32.599 align:start position:0%
suffice all right um so I think that
concludes<00:08:28.919><c> our</c><00:08:29.159><c> talk</c><00:08:29.560><c> for</c><00:08:29.720><c> today</c>