Have anybody tested to populate a sql ce database with a table containing 40
000 + items?
I'm developing an application for pocket pc 2002 and SQL CE.
/Mats Boberg
I'm developing an application for pocket pc 2002 and SQL CE.
/Mats Boberg
Quote:>-----Original Message-----
>Have anybody tested to populate a sql ce database with a
table containing 40
>000 + items?
>I'm developing an application for pocket pc 2002 and SQL
CE.
>/Mats Boberg
>.
I've not had any problems whatsoever, either with the number of records or
the size of the database. It also syncs happily through IIS and SQL Server
replication. I am only using the large table for reference data so there
may be other issues involved with updates. I don't know. Searching the
50,000 records also seems to show perfectly acceptable performance in my
view.
Quote:> I bet it will crash .... :)
> Keep us inform !
> >-----Original Message-----
> >Have anybody tested to populate a sql ce database with a
> table containing 40
> >000 + items?
> >I'm developing an application for pocket pc 2002 and SQL
> CE.
> >/Mats Boberg
> >.
Chris.
Quote:>-----Original Message-----
>I bet it will crash .... :)
>Keep us inform !
>>-----Original Message-----
>>Have anybody tested to populate a sql ce database with a
>table containing 40
>>000 + items?
>>I'm developing an application for pocket pc 2002 and SQL
>CE.
>>/Mats Boberg
>>.
>.
--
Brad
This posting is provided "AS IS" with no warranties, and confers no rights.
Quote:> Have anybody tested to populate a sql ce database with a table containing
40
> 000 + items?
> I'm developing an application for pocket pc 2002 and SQL CE.
> /Mats Boberg
Nice to hear! Now I can relax!
/Mats
Quote:> Have anybody tested to populate a sql ce database with a table containing
40
> 000 + items?
> I'm developing an application for pocket pc 2002 and SQL CE.
> /Mats Boberg
1. Connection to other database than SQL Server or Connection to SQL CE
Hi,
I read in "Accessing a Non SQLServer DB on PPC 2002" that not even .cdf is
not supported! I just want to make shure there is no other way than to write
my own DLL. I have a scenario where SQL Server would be a bit oversized (and
maybe too expensive). So my first question is: Connection to something
different than SQL Server can only be done over writing my own DLL? My
second question is: Can my SQL Server CE be connected from my desktop
computer via ActiveSync or (W)LAN?
Thank you very much,
Christoph
2. Supra 288 locks mouse and keyboard up:
3. Database Developer / SQL Sever Developer / LOCAL / NO. H1
5. Password to connect to the SDF SQL CE database
7. How can I encrypt database file of SQL SERVER CE 2.0 !
8. Cache SQL CE database connections
9. Creating SQL Server CE Database
10. Error with SQL Server CE Database
11. Multi-Access of Local SQL CE Database
12. Creating SQL CE 2 database in code