Hi -

I have just purchased EntitySpaces and VistaDB and I am very excited to begin using them.  However I am seeing poor performance issues, and I would appreciate some guidance.

If I just click the "Data" node in the DataBuilder app from VistaDB, the data comes back almost instantly, less than 2 seconds.  However in my app using EntitySpaces it takes a very long time (20 seconds).  The table is a list of customers with around 11000 records in it.

There are primary keys defined, and I am running a release version of the .exe, not in the ide.  Plus it doesn't matter if it is the first time or the 10th. 

The same code running against an access database is orders of magnitude quicker, but when using vistadb it is very slow just doing a simple query.load() on a collection.   Any suggestions on how to trouble shoot this one?  I'm sure I just don't have this set up correctly...

Thanks!

Chad

When we first started supporting VistaDB, some users reported performance issues with INSERTs, which we confirmed in our tests, but we were able to work with VistaDB's support staff, and they quickly got it resolved in their next release.

http://community.entityspaces.net/forums/thread/2083.aspx

Since then, we have not heard any other complaints, and we have never had any regarding load times. In our latest performance tests against Build 32, it looks as though they've improved performance significantly since Build 25. Our 10,000 record Query.Load() takes less than 1/2 a second. In our tests, VistaDB takes about two times longer than MS Access, and 3 times longer than MS SQL Server for a 10,000 record load, but with them all being sub-second response times, it really should not be significant.

Perhaps, it is not the number of records, but the number and/or type of columns? Is the problem with the load, or are you filling in a DataGridView?

Ok - done some more testing.  It really appears to be the load.  There are a large number of columns, but even when I trim it down to 4 columns it is still slow.  I am binding to a datagrid, but I commented that out and just threw up a message box when it was done loading and it appeared to be the same amount of time.  As I mentioned in my first post, all the tests were done outside of VS, by clicking the .exe.

I then setup a dda load using vistadb and a datagrid as they demonstrate in their data builder source.  It loads almost instantaneously.  This is so close to really being exceptional, I'd like to see the data load quicker knowing it is possible after seeing their dda loader.  Not sure what is next to check?

Thanks,

Chad

Hi David -

I tried to email this to you and just got this message back.  It appears your mail box is full.

Hi. This is the qmail-send program at mta02.internetmailserver.net.
I'm afraid I wasn't able to deliver your message to the following addresses.
This is a permanent error; I've given up. Sorry it didn't work out.

<support@entityspaces.net>:
The users mailfolder is over the allowed quota (size). (#5.2.2)

Do you have a different email address to send to?

 Thanks!

Chad

Sorry... Looks like we got bombarded lately with "Greeting Cards from old classmates."

You know the drill with posted email addresses. There should be plenty of space now.

Not a problem, I re-sent it now.  I also included the xml export of the data.

I emailed you my test sln. My results were very consistent. The first load of over 11K records was just over 3 seconds. All subsequent loads were under 3 seconds. Grid binding only added a fraction of a second more. Take a look and let me know your results.

VistaDBLarge:
Load Large Table:
0: 11584: 00:00:03.3437500
1: 11584: 00:00:02.8750000
2: 11584: 00:00:02.8281250
3: 11584: 00:00:02.7343750
4: 11584: 00:00:02.8437500
Grid: 00:00:00.2031250