Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Performance Issue For Memory Table |
Fri, Aug 18 2006 6:18 AM | Permanent Link |
Ravi | hi,
I am using DBISAM Table Component of Version 3.17. I have created a table of 169 Columns and Record Size is 2515. i am inserting 7000 records into the table 1) As Local Table (.DAT File Exists in Disk) - Time Taken - 3.40 Seconds approx 2) As Memory Table - Time Taken - 1 Minute approx Can Somebody let me know is this difference is because of RAM or Paging? I have enough RAM of about 2 GB in my machine. Thanks in Advance. Regards S.Ravi |
Sat, Aug 19 2006 3:08 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ravi,
<< I am using DBISAM Table Component of Version 3.17. I have created a table of 169 Columns and Record Size is 2515. i am inserting 7000 records into the table 1) As Local Table (.DAT File Exists in Disk) - Time Taken - 3.40 Seconds approx 2) As Memory Table - Time Taken - 1 Minute approx Can Somebody let me know is this difference is because of RAM or Paging? >> 3.17 may be using a smaller internal block size for in-memory files than later versions as well as re-allocating when growing the file(s), and this may be contributing to the issue. 3.30 uses a 4096-byte block size when allocating or reallocating, which may make it slightly faster. 4.x doesn't do reallocation during a grow, so it is much faster than 3.x in general with in-memory files, especially when appending a large number of records. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Aug 22 2006 12:59 AM | Permanent Link |
Praveen | Tim,
So is there a workaround for this ? Thanks Praveen |
Tue, Aug 22 2006 2:51 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Praveen
Move to 3.30 or better 4.24 Roy Lambert |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |