in reply to Re^3: 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)

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,
  • Comment on Re^4: 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^5: 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:59 UTC

    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.
[reply]
      I don't know if you've seen my answer due to the fact i've replied on the other branch

      (I'm not familiar with the email alert and the followers on a topic on perl monks).

      Please forgive me if you were already aware of my answer and my apologies if it's hard to read me with my bad english learning

      Best regards,
[reply]

        Given that $uniq_values is a hash reference, could you tell me what you think this construct does? 

        \%{$uniq_values}

        [download]

        And why you think it is necessary?

        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.
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom