FJ Software

Hi

We've discussed earlier how to make a better format for storing SMS so that it won't be so slow when many SMS are in the archive.
You changed the format to a new one which is somewhat better but still not optimal.

I believe the solution i to use SQLite!

You get the best from both worlds, plain textfile so no drivers are needed and you get the bonus of being able to search, index and do all the stuff you normally would do with a database.

http://www.sqlite.org/

Please do consider it even though it means spending some time. It will be well worth the effort and open up for lots of new feature possibilites!

I already thought about a real database. But when i do it this way then i have also to distribute the Databsae-Drivers and AFAIK its not allowed to distribute the MS-Drivers.

SQLite is also no good possibility cause there are no good librarys which i can use in VB6.

Have you looked at this for VB6?
http://www.terrainformatica.com/sqlitedb/

What about Access. Bth the drivers and the databse file itself are free and well supported in VB6

Did you ever take a look how big the drivers are for access ? They have (compressed in a setup) 5,8 MB. Thats too much. After this the setup of MyPhoneExplorer would grow up to 8MB - only cause this silly MS-Drivers and cause you think you have to store tenthousands of messages in the archive. How many messages you have currently in the archive ?

I don't mind have to download a larger file (does anybody still use a modem??), nor do I mind having a larger programme installed as harddisk space are plenty and memory likewise.

But I do mind programs that perform less good

I have around 6000 SMS now.
My friend has 3000.

The text file approach is fine for small archives, but the whole point of an archive must be to store several in it

You ought to reconsider using Access as eerything will become so much easier to do!
And new features will be possible which would be very nice.

Also, load balancing will become easier as you can limit the amount you show rather than loading the whole text file into memory and first then limiting after the damage is done.

Maybe for you its unnecessary if the Setup has 3MB or 9MB - but for Modem-Users (and there are still alot of it) and for my Webhoster it would be too much.

Do you honestly believe that a modem user (there aren't many left!) actully cares about downloading the a little larger file if he receives a program that actually works?

That is a very odd trade off.
I believe the problem lies elsewhere and the file size is just a cover for the real reason, like you really can't be bothered to do some work to fix the horrible SMS file

I have never really understood the way you work. Its always half solutions that just barely makes it through and for some odd reason, that is enough in your world.

Why not program for optimum performance and durabilty?

Hy - you are talking about DSL-Users. I am talking about normal PC's. There is a thing which wonders me: I have a Athlon 2800+ with 512 MB RAM - absolutly no problem to handle 10.000 messages.

Please read my posts - i don't talk here for fun. Its also a problem to host MyPhoneExplorer if the size grows up to 9 MB. Currently i have traffic about 690 GB (=13.000 Downloads daily + normal Website-Traffic) . I cannot blow up the traffic cause a senseless driver up to 2 TB. There are maybe 5% of the users which use the archive in this extreme way like you.

You never understood the way i work ? Near every user think that MyPhoneExplorer is near perfect - i don't think that there are many things which i've done wrong. Please note that i have decide things for thousands of users and not only for you.

At last: If you read the logfiles then you'll see how long MyPhoneExplorer needs to read and save the archive: With 10.000 messages MyPhoneExplorer needs 250ms to read and 100ms to save the archive. The rest of the time is needed to resfresh the interface. And this task cannot be done faster with a database.

Hi, I use My Phone Explorer 1.8 and "sms.dat" file is damaged, so I can't open it.
It's possible to fix it?

thanks

How it got damaged ? If you want you can send me the file zipped via email.