EDB Max No. of Records in a Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Compe2001 - 07 Apr 2008 23:16 GMT

Hi guys,

Is the max number of records in a table(database in the CEDB/EDB world)
0xFFFF i.e. 65,535?

I see in this in windbase.h.
// Max number of records allowed in a single database.
#define CEDB_MAXNUMRECORDS 0xFFFF

How about SQL Server Compact Edition? Is the number of record size more than
the 65K limit for EDB?

We are researching what DB technology to use for our industrial controller
used as a hardcore datalogger with storage being the SD Card (1+ GB).

Thanks,
Compe2001

Reply to this Message

ErikEJ - 08 Apr 2008 07:52 GMT

Information about SQL Compact Edition limits is available here:
http://msdn2.microsoft.com/en-us/library/ms172451.aspx

There is a max database size limt of 4 GB, but no limit on number of rows.
(Although there will be pratical limits).

Signature

Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

> Hi guys,
>
[quoted text clipped - 14 lines]
> Thanks,
> Compe2001

Reply to this Message