search

jonwagner / Insight.Database

Fast, lightweight .NET micro-ORM
Other
861 stars 145 forks source link

Before using Insight.Database, I have a few questions #413

Closed SuheylZ closed 4 years ago

SuheylZ commented 5 years ago

I want to use Insight.Database in a large cloud based system. I have a few questions though:

  1. How stable it is for production system? Does it have any issues that might hamper its use in production environment?
  2. Is it still actively maintained?
  3. Is it extensible? for instance for NoSql databases like Cassandra and similar?
  4. Is there any performance benchmark available for high write or high read environment?
keerthirajap commented 5 years ago

How stable it is for production system? Does it have any issues that might hamper its use in production environment? - I have used with MSSQL, DB2 and Oracle with than 6 projects. No issues I have faced.

Is there any performance benchmark available for high write or high read environment? Yes, Check this repo -> https://github.com/InfoTechBridge/OrmBenchmark Insight seems fine in performance.

Jaxelr commented 5 years ago
  1. This question is difficult to answer, considering what scenarios you would be using it for?
    • If you plan to have lots of customizable result sets, insight is highly practical and with a succint API.
    • Plan on using BulkInserts? Insight supports them out of the box.
    • Async? Multiple Active Connections? Insight is flexible for those scenarios, you can even roll your own record reader.
    • Auto Implementation saves you LOTS of work, if you understand its usage and scenarios.
  2. Sure, as far as i know all collaborators have jobs and we dont get paid for OSS, so we are not available 24/7.
  3. No and i dont think it is considered on future plans. Managing NoSql databases is a whole other monster and i would not suggest doing so with a transactional ORM. But it does manage most SQL Providers.
  4. The benchmarks on OrmBenchmark could use an upgrade, so be on the lookout for a PR. I would also like to create a repo using BenchmarkDotNet which would give us a bit more perspective.
jonwagner commented 4 years ago

As for active maintenance, I might not be putting out same-day fixes anymore, but I do intend to keep producing new builds as issues arise and new features are requested.

SuheylZ commented 4 years ago

thanks a lot. i have started giving it a try in a test app. I will try to post my results and findings or any questions if i may have.

Get Outlook for Androidhttps://aka.ms/ghei36

From: Jon Wagner notifications@github.com Sent: Thursday, November 28, 2019 11:14:02 PM To: jonwagner/Insight.Database Insight.Database@noreply.github.com Cc: MercedeX suheylz@hotmail.com; Author author@noreply.github.com Subject: Re: [jonwagner/Insight.Database] Before using Insight.Database, I have a few questions (#413)

As for active maintenance, I might not be putting out same-day fixes anymore, but I do intend to keep producing new builds as issues arise and new features are requested.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/jonwagner/Insight.Database/issues/413?email_source=notifications&email_token=ADIXIO5ZQ4FVOC5UMSFTJRLQWAC6VA5CNFSM4JOS4VJKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEFNHQOQ#issuecomment-559577146, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ADIXIOYD6Q2TWLA3QKB2DP3QWAC6VANCNFSM4JOS4VJA.

Jaxelr commented 4 years ago

I have created a Insight Benchmark repo that could give you more information about the performance and allow you to thinker and evaluate what scenarios work for you in terms of performance. Closing this issue.