SQL CE sever + large product database

SQL CE sever + large product database

Post by Mats Bober » Sat, 26 Apr 2003 21:57:15



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

 
 
 

SQL CE sever + large product database

Post by Johnanta » Sat, 26 Apr 2003 22:14:20


I bet it will crash .... :)
Keep us inform !

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

>.


 
 
 

SQL CE sever + large product database

Post by Ben » Sat, 26 Apr 2003 22:37:18


I'm working with an app at the moment that has a table containing 50,000
records.  The .sdf file is around 10.5Mb now.

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

> >.

 
 
 

SQL CE sever + large product database

Post by chris » Sat, 26 Apr 2003 22:59:24


Yes, created one with 110,000+ records and it was fast.

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

>>.

>.

 
 
 

SQL CE sever + large product database

Post by Brad Syputa - M » Sun, 27 Apr 2003 01:51:52


Works fine for me as well. Just make sure you have enough memory(storage
card preferred) on your device. During the initial merge, SQLCE will buffer
memory equal to the size of your DB. Specifying the Temp directory as a
storage card can help if you run into out of memory issues.

--
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

 
 
 

SQL CE sever + large product database

Post by Mats Bober » Sun, 27 Apr 2003 20:22:43


Thanx for all answers!

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

4. (Fwd) DBD::ODBC module

5. Password to connect to the SDF SQL CE database

6. Router/hub combo

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