Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Perhaps you should consider the fact that NHibernate (like most ORMs) is not particularly suited (or intended) for these types of bulk-loading scenarios. How many rows are you trying to load, give or take? What are you trying to do? Pre-populate a cache? Do batch-like processing? </p> <p>My gut feeling is that you should seriously consider the purpose of your app and choose the underlying technologies accordingly. Perhaps you can shed some light on your intentions/requirements?</p> <p>EDIT OK, from your comments I understand what it is you're trying to do here. The first thing I'd do is create a simple prototype using raw ADO.NET to load the same data, to get a feel for the best performance attainable using standard data access and in-memory collections. Next, fiddle around with different collection types to see what performs well when populating and searching. If loading data like this is still too slow, it's time to start looking at other methods of loading the data: file-based from a local data file, hydrating pre-serialized objects, some form of fast on-demand loading, etc.</p>
    singulars
    1. This table or related slice is empty.
    1. PONHibernate latency is very high
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UStijmenvdk
    1. UStijmenvdk
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks for the quick reply! I am trying to load more than 500K rows, each of which is an entity. Each entity can point towards other entities. I am trying to populate this list as fast as possible with all these inter relations. I am not writing anything to the DB, but after experimenting with lazy loading I found it doesn't suit my needs. The next best thing I could think of is somehow loading the data in a different thread in some sort of producer-consumer pattern, but I have no idea how you do that. Any ideas? Do you have any tips for other technologies? Thanks!
      singulars
      1. PO
      1. USIdo Cohn
    2. COI still have no clue on why you'd want to load that many inter-related entities. That makes it hard to come up with suggestions. Loading the data in the background can make sense, but only if your app can start to do whatever it needs to do without all the data in place. In short, tell us what you want to achieve, what your requirements are, maybe then we can give you a proper suggestion or two.
      singulars
      1. PO
      1. UStijmenvdk
    3. COI am actually loading a word dictionary, when each word relates to others. The background thing could be very tricky in our application, as we would have to manually load an entry that has not been loaded before. The problem is that any one of those words could be asked for at any time. Our only requirements are that all the data be loaded as fast as possible. I also tried using a stateless session, but got an exception that stateless sessions can't fetch collections...
      singulars
      1. PO
      1. USIdo Cohn
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload