Advertisement
Guest User

Untitled

a guest
Sep 18th, 2017
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 20.50 KB | None | 0 0
  1.  static class Program
  2.     {
  3.         static string _baseDir = "file_test";
  4.  
  5.         static void Main()
  6.         {
  7.             var count = 10000;
  8.             var src = @"At Cashbloom, we understand that choosing a funding source is a delicate decision.|We value all applicants and view each business uniquely, taking all circumstances into consideration.|The principals of our company come from a small business background, which is why we understand the day to day challenges and what it takes to be successful.|We underwrite accordingly and want to fund a business in a way that the payback can be easily managed.|Because our goal is to keep businesses thriving, we tend to build long term relationships with all of our merchants.|We aim to provide an exceptional level of support to all of our merchants from application, to funding and most important, post funding.|All merchants will receive a designated Account Executive to assist with the submission, a Funding Coordinator to make the funding process simple and a Renewal Funding Executive that provides continued client support after the funding.|Once we confirm that your business is qualified for funding, the process is simple; we customize an advance based on your specific business needs.|This is why we offer you the flexibility of using either your existing merchant account provider or even your own bank account.|No new accounts or bank switches necessary.|At Cashbloom, we with work with the flow of your business; this is why we only base your repayment on a percentage of your sales, rather than a fixed amount.|This way, if you have a slower month, your repayment will be smaller.|With no application fees or collateral required, the real effort is taking the time to ask.|So give us a call or submit an inquiry today, we will be in contact soon with options for you and your business to consider.|Cashbloom stepped in when my business needed it most.|My advance with Cashbloom has been helpful in more ways than one.|With help from Cashbloom I was able to buy new equipment and hire employees.|They gave us the jumpstart we needed to take our business to the next level - I recommend them above all others!|Look no further that Cashbloom, their team has it all.|Small Business Finance Made Simple.|Getting a credit card sales loan has never been this easy!|Cashbloom is a leading provider of Merchant Advances in the US and Canada to small and medium sized businesses, offering innovative funding solutions.|Complete the form below to find out how much YOUR business qualifies for.|Find Out How Much You Qualify For.|No Obligations, No Contracts.|Monthly Credit Card Sales:.|Because our goal is to keep businesses thriving, we tend to build long term relationships with all of our merchants..|All merchants will receive a designated Account Executive to assist with the submission, a Funding Coordinator to make the funding process simple and a Renewal Funding Executive that provides continued client support after the funding..|Some of the Types of Business We Fund:.|DIRECT FUNDER: Most companies that offer working capital are brokers and resellers; they add unnecessary fees and delay the process whereas we are the funding source — no middle man.|HIGHEST APPROVAL RATIO: We find ways and reasons to approve accounts and say yes.|LOWEST RATES IN THE INDUSTRY: We reward premium merchants with premium rates.|REPUTABLE: We are a trusted member and have earned an A rating through the Better Business Bureau BBB.|AND THE MOST IMPORTANT REASON WE ARE THE BETTER CHOICE IS...|We strive to have a personalized, one-on-one long term business relationship with all our clients.|Your account executive will be there to help guide you throughout the process, and most important, after you have been funded!|We pride ourselves on providing exceptional customer service each and every day and we look forward to seeing how we can help you and your business.|How Much Can I Get?|How Does Cashbloom Work?|Once we confirm that your business is qualified for funding, the process is simple; we customize an advance based on your specific business needs..|Do I Have To Switch Banks or Open a New Account?|No new accounts or bank switches necessary..|So give us a call or submit an inquiry today, we will be in contact soon with options for you and your business to consider..|Professionalism, timeliness, helpfulness, reliability and flexibility; everything a business needs to consider when looking for a funder.|Cashbloom is a Licensed California Finance Lender.
  9. We finance all types, makes and models of boats, at virtually any price range.|We offer some of the lowest boat rates and extended boat terms in the boat financing industry and with competitive rates , regardless of how much you are financing.|We want to earn your business regardless of your budget.|We also have an excellent refinance program to help you save money on your current loan.|At Southeast Financial we strive to get your boat loan approved on the Same Day you apply.|Our online boat application is simple to complete and we use the highest level of online transaction security available to protect your personal information.|Customer service is the key at Southeast Financial no matter what size boat you are financing.|And thanks to the high volume of business we do with banks that specialize in financing for boats and other high-end recreational vehicles, we can offer some of the best rates in the industry.|We strive to work with a wide variety of customers.|Southeast Financial offers secure boat loans online for virtually any type of personal-use vessel that can take to the water.|Our lending specialists will process your application and turn around a credit decision the same day you apply, so you can move forward as quickly as possible.|Our financing is unfortunately not available for boat purchases in Alaska and Hawaii.|Login here to check your application status.|What makes us different?|Information on this site about loans and the information provided above are made available to you as self-help tools for your independent use.|We can not and do not guarantee their accuracy or their applicability to your circumstances.|We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.|No matter what the reason,...|The joy of owning an RV is indescribable.|The freedom of the open road alone is priceless.|After a while, however, the refinancing option appeals to an RV owner because...|Our finance experts are happy to assist you with any questions that you may have.|Fill out the form below to send a message:.|Rate is subject to loan program guidelines and credit approval.|All applicants may not qualify for listed rate.|Certain Fees, closing costs, down payment and restrictions may apply.|Rates and terms may vary and are subject to change without notice.|Rate and term can vary depending on: credit history, collateral type, age of collateral, loan amount, loan term, down payment amount, state of residency and other criteria.|Credit scores can vary depending on credit reporting agency.|Southeast Financial does not offer financing for Full-timers.|Southeast only offers financing for recreational use.|Fixed rates starting at.|There are many reasons you should use Southeast Financial.|Great Loan Rates and Terms.|Boat Financing For All Circumstances.|Safe, Secure, and Easy Application Process.|See what they are saying:.|Get pre-approved with Southeast today.|Fixed rates starting at..|Current Interest Rates Starting At:..|Your Monthly Payment is.|B, and C Class Motorhomes?|How will you spend the longer days?
  10. Do you have an account?|There are a number of brands who specialise in instant cash loans with online approval and they can give you the money you need in just a few hours.|Find out how you can apply and get funded today.|This is a short term loan offer with a fast and easy online application for bad credit borrowers who are employed.|It can be expensive to borrow small amounts of money and borrowing may not solve your money problems.|Instant cash loans can vary depending on the lender you apply with, the amount you earn and what your credit history is like.|Some lenders limit the amount you can borrow on your initial loan, so it is always important to check the criteria of each lender before you apply.|If you ensure that all the documents you need to apply are in order, you could potentially maximise your borrowing power.|Instant cash loans are small personal loans which you can receive quickly.|Lenders that offer these loans generally have flexible lending terms because of the nature of the loan.|Here are some features these type of loans come with: The one thing that you will notice about instant cash loans is that they have a higher cost than traditional loans.|Take a look at the fees and rates you will be charged and make sure it will be manageable on your budget.|Some lenders may also allow you to pay the loan back early, which is a great option because it will help you save you on fees.|There might be the temptation to keep using instant cash loans, but try not to do this.|They should only ever be used for an emergency.|However, getting the right loan and the right lender will potentially save you a lot of trouble down the track.|Your bank statements can be submitted as PDFs or by giving the lender secure, read-only access to your account.|Cash lenders will also need to verify your identity.|The eligibility criteria for instant cash loans is generally less strict than other personal loans.|Most lenders focus on your income and current financial situation rather than your credit history.|Some lenders will allow you to repeatedly borrow from them if you prove yourself to be a responsible borrower and may increase the amount you are able to borrow.|Getting quick cash can be easy, provided you meet some basic criteria.|Find out the difference between personal loans and short term payday loans to see which will be best for you.|You can access financing even with a bad credit history.|Need money in a hurry but have credit?|A payday loan may help you meet your current financial commitments.|Click here to cancel reply.|Subscribe to our newsletter Notify me of followup comments via e-mail.|Disclaimer: At [HOST] we provide factual information and general advice.|Rates and fees mentioned in comments are correct at the time of publication.|By submitting this question you agree to the [HOST] privacy policy ,.|I am looking for a lender who will let me borow the money without any transfer fees or hidden charges.|Would you mind to help me?|You can compare your loan options using the table on this page.|You can find out more about the lenders above and their loans by clicking on their names.|The time it takes to get your cash transferred will depend on your banking institution.|You can compare a range of same day loans or prepaid debit card loans.|Please refer to our FSG - Financial Products.|Please refer to our Credit Guide for more information.|We can also provide you with general advice and factual information on about a range of other products, services and providers.|We are also a Corporate Authorised Representative of Countrywide Tolstrup Financial Services Group Pty Ltd.|Please refer to our FSG - General Insurance.|We hope that the information and general advice we can provide will help you make a more informed decision.|We are not owned by any Bank or Insurer and we are not a product issuer or a credit provider.|If you decide to apply for a product or service through our website you will be dealing directly with the provider of that product or service and not with us..|We endeavour to ensure that the information on this site is current and accurate but you should confirm any information with the product or service provider and read the information they can provide.|If you are unsure you should get independent advice before you apply for any product or commit to any plan.|We compare from a wide set of major banks, insurers and product issuers.|You should consider whether the products featured on our site are appropriate for your needs and seek independent advice if you have any questions.|On a regular basis, analytics drive the creation of a list of popular products.|Where these products are grouped, they appear in no particular order.|We try to take an open and transparent approach and provide a broad based comparison service.|However, you should be aware that while we are an independently owned service, our comparison service does not include all providers or all products available in the market.|Some product issuers may provide products or offer services through multiple brands, associated companies or different labelling arrangements.|This can make it difficult for consumers to compare alternatives or identify the companies behind the products.|However, we aim to provide information to enable consumers to understand these issues.|Providing or obtaining an estimated insurance quote through us does not guarantee you can get the insurance.|Acceptance by insurance companies is based on things like occupation, health and lifestyle.|By providing you with the ability to apply for a credit card or loan we are not guaranteeing that your application will be approved.|Please read our website terms of use for more information about our services and our approach to privacy.|Compare and save now.|Find a better personal loan deal.|Compare market leading home loans.|High Interest Savings Accounts.|Sending money to family overseas?|Planning to travel soon?|Check out one of our travel money location guides.|How much can I borrow?|Balance transfer savings calculator.|Personal loan repayment calculations.|How much will it cost?|Calculate your home loan repayments.|Types Compare Payday Loans.|Bad Credit Payday Loans.|No Credit Check Loans.|Loans From Cash Converters.|Guides High income payday loans.|Australian payday loans vs the world.|Who are payday borrowers?|Straight to your inbox.|By signing up, you agree to the [HOST] privacy policy.|A fast cash loan can cover you for when the unexpected occurs.|Sunshine Short Term Offer This is a short term loan offer with a fast and easy online application for bad credit borrowers who are employed.|More Go to site.|Read the Sunshine Short Term Offer terms and conditions.|No short term loans found.|Go to site Read the full review.|Warning about Borrowing Do you really need a loan today?|Instant cash loans could help you out of the tight spot.|Fixed fee schedule Payday loans are regulated by the government.|The drawbacks High fees While these loans are regulated, the higher risk for the lender means that you will pay more fees for the convenience of the cash.|Find out more about bad credit personal loans Compare a range of short term loan options Need a loan with no credit check?|Was this content helpful to you?.|Nimble Short Term Loan.|Compare Unsecured Bad Credit Loans.|Personal loans vs payday loans.|Payday Loans in Darwin.|You are about to post a question on [HOST].|Do not enter personal information eg.|We cannot provide you with personal advice or recommendations.|Your answer might already be waiting — check previous questions.|Subscribe to our newsletter.|Notify me of followup comments via e-mail.|Important information about this website.";
  11.             var dir = "text";
  12.             string postfix = Guid.NewGuid().ToString();
  13.  
  14.             Stopwatch sw;
  15.  
  16.             ///////////////////////////////////////////////////////////////////////////////////////////////////////////////
  17.  
  18.             var sqliteDbFile = "sqlite_test.db";
  19.             try { File.Delete(sqliteDbFile); } catch { }
  20.             SQLiteConnection sqconnection = new SQLiteConnection(string.Format("Data Source = {0}; Journal Mode=Off;", sqliteDbFile));
  21.             sqconnection.Open();
  22.             try { new SQLiteCommand("CREATE TABLE test_table (key varchar(500), content text)", sqconnection).ExecuteNonQuery(); }
  23.             catch { }
  24.             try { new SQLiteCommand("CREATE INDEX my_url_idx ON test_table(key)", sqconnection).ExecuteNonQuery(); }
  25.             catch { }
  26.             SQLiteTransaction sqtrans = sqconnection.BeginTransaction();
  27.             var insCommand = new SQLiteCommand("insert into test_table (key, content) values (:key, :content)", sqconnection, sqtrans);
  28.             insCommand.Parameters.AddRange(new[] { new SQLiteParameter("key", ""), new SQLiteParameter("content", "") });
  29.             sw = Stopwatch.StartNew();
  30.             for (int i = 1001; i < 1000 + count; i++)
  31.             {
  32.                 var key = i + postfix;
  33.                 insCommand.Parameters[0].Value = key;
  34.                 insCommand.Parameters[1].Value = i + src;
  35.                 insCommand.ExecuteNonQuery();
  36.                 if (i % 1000 == 0)
  37.                 {
  38.                     sqtrans.Commit();
  39.                     sqtrans = sqconnection.BeginTransaction();
  40.                 }
  41.             }
  42.             sqtrans.Commit();
  43.             sqconnection.Close();
  44.             sw.Stop();
  45.             Console.WriteLine("Write sqlite time: " + sw.Elapsed); //4s
  46.  
  47.             for (int x = 0; x < 3; x++)
  48.             {
  49.                 sqconnection = new SQLiteConnection(string.Format("Data Source = {0}; Journal Mode=Off;", sqliteDbFile));
  50.                 sqconnection.Open();
  51.                 var getCommand = new SQLiteCommand("select content from  test_table where key=:key", sqconnection);
  52.                 getCommand.Parameters.AddRange(new[] { new SQLiteParameter("key", "") });
  53.                 sw = Stopwatch.StartNew();
  54.                 for (int i = 1001; i < 1000 + count; i++)
  55.                 {
  56.                     var key = i + postfix;
  57.                     getCommand.Parameters[0].Value = key;
  58.                     var content = getCommand.ExecuteScalar() as string;
  59.                     if (DateTime.Now.Ticks > content.Length) { Nop(); }
  60.                 }
  61.                 sqconnection.Close();
  62.                 sw.Stop();
  63.                 Console.WriteLine("Read sqlite time: " + sw.Elapsed); //0.7sec
  64.             }
  65.  
  66.             /////////////////////////////////////////////////////////////////////////////////////////////////////////////
  67.  
  68.             var sqlceDbFile = "sqlce_test.db";
  69.             try { File.Delete(sqlceDbFile); } catch { }
  70.             File.WriteAllText(sqlceDbFile, "");
  71.             SqlCeConnection sqcceconnection = new SqlCeConnection(string.Format("Data Source = {0}; Max Database Size=4091", sqlceDbFile));
  72.             sqcceconnection.Open();
  73.             try { new SqlCeCommand("CREATE TABLE test_table (key1 nvarchar(500), content ntext)", sqcceconnection).ExecuteNonQuery(); }
  74.             catch { }
  75.             try { new SqlCeCommand("CREATE INDEX my_url_idx ON test_table(key1)", sqcceconnection).ExecuteNonQuery(); }
  76.             catch { }
  77.             SqlCeTransaction sqcetrans = sqcceconnection.BeginTransaction();
  78.             var insCeCommand = new SqlCeCommand("insert into test_table (key1, content) values (@key1, @content)", sqcceconnection, sqcetrans);
  79.             insCeCommand.Parameters.AddRange(new[] { new SqlCeParameter("key1", ""), new SqlCeParameter("content", "") });
  80.             sw = Stopwatch.StartNew();
  81.             for (int i = 1001; i < 1000 + count; i++)
  82.             {
  83.                 var key = i + postfix;
  84.                 insCeCommand.Parameters[0].Value = key;
  85.                 insCeCommand.Parameters[1].Value = i + src;
  86.                 insCeCommand.ExecuteNonQuery();
  87.                 if (i % 1000 == 0)
  88.                 {
  89.                     sqcetrans.Commit();
  90.                     sqcetrans = sqcceconnection.BeginTransaction();
  91.                 }
  92.             }
  93.             sqcetrans.Commit();
  94.             sqcceconnection.Close();
  95.             sw.Stop();
  96.             Console.WriteLine("Write sqlce time: " + sw.Elapsed); //4s
  97.  
  98.             for (int x = 0; x < 3; x++)
  99.             {
  100.                 sqcceconnection = new SqlCeConnection(string.Format("Data Source = {0}; Max Database Size=4091", sqlceDbFile));
  101.                 sqcceconnection.Open();
  102.                 var getCommand = new SqlCeCommand("select content from  test_table where key1=@key1", sqcceconnection);
  103.                 getCommand.Parameters.AddRange(new[] { new SqlCeParameter("key1", "") });
  104.                 sw = Stopwatch.StartNew();
  105.                 for (int i = 1001; i < 1000 + count; i++)
  106.                 {
  107.                     var key = i + postfix;
  108.                     getCommand.Parameters[0].Value = key;
  109.                     var content = getCommand.ExecuteScalar() as string;
  110.                     if (DateTime.Now.Ticks > content.Length) { Nop(); }
  111.                 }
  112.                 sqcceconnection.Close();
  113.                 sw.Stop();
  114.                 Console.WriteLine("Read sqlce time: " + sw.Elapsed); //0.7sec
  115.             }
  116.  
  117.             Console.ReadLine();
  118.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement