Today was the first day of my 2 weeks of crash programming… I first had to get some stuff out of the way to get a client’s issues resolved. They imported a bunch of data into our product. The import took 3 days – that is how much there was. They had over a million documents to import. There were 20 million document values records. When they would try to do a search, the system would time out. It was my job to figure out a way to make it faster. It had to do with document level security. At first I thought there was nothing I could do, but that really wasn’t an option. I had to come up with something. In my talk yesterday I expressed my testimony of the power of prayer. I said that God is the greatest programmer. He knows all programming languages and the most advanced algorithms. I told of times he has guided me to find solutions. So I put that to the test again today. I really needed to get it done and I had already spent over a week trying to figure out ways to make it happen. I basically rewrote how document security worked and got a search that was taking 30 minutes down to 11 seconds! Now I understand if this were the internet, that would be terrible, but considering the improvement, 11 seconds was more than acceptable. I’m sure that with better hardward it could run even faster, but that is out of my control. I was so happy all night that I got this off of my plate! I asked for the Lord’s help this morning and he provided a miracle.
Recent Comments