in reply to Re: Sqlite: Threads and inserts into a different database for each one. (1 thread fast, >1 slow: BY YOUR DESIGN!)
in thread Sqlite: Threads and inserts into a different database for each one. (1 thread fast, >1 slow)

Sure, sure,
I just try to reduce the part of the code who i haven't provided and construct a sample dataset (but i have difficulties to construct it from scratch)

I'm pretty sure you're right about the "poor coding choices" because i'm a beginner and i scratch my head since days to try to figure out where i've made mistakes.

May i join some tabulate files for the data than i retrieve from mysql? it will help me a lot

Os: linux debian Perl: v5.14.2 Best regards,
  • Comment on Re^2: Sqlite: Threads and inserts into a different database for each one. (1 thread fast, >1 slow: BY YOUR DESIGN!)

Replies are listed 'Best First'.
Re^3: Sqlite: Threads and inserts into a different database for each one. (1 thread fast, >1 slow: BY YOUR DESIGN!)
by BrowserUk (Patriarch) on Apr 07, 2014 at 15:20 UTC
    May i join some tabulate files for the data than i retrieve from mysql? it will help me a lot

    Sorry, but I do not understand that question -- it seems to have lost a lot in translation. would you try re-phrasing it for us?


    With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
    Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
    "Science is about questioning the status quo. Questioning authority".
    In the absence of evidence, opinion is indistinguishable from prejudice.
      The datas than i need to process comes from a mysql database.
      I was asking if it was helpful to upload a sample dataset or the full script is sufficient to analyse where i'm doing wrong?
      Thanks for taking time,
      Br,

        Yes. A small sample of the input data would be extremely useful. Just enough to exercise the code through 3 or 4 iterations is enough.

        (The full -- or a least working, cut-down showing all the relevant code -- is a requirement if you are to get answers that are anything more than guesswork.)


        With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
        Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
        "Science is about questioning the status quo. Questioning authority".
        In the absence of evidence, opinion is indistinguishable from prejudice.