yathit / ydn-db

Javascript database module for Indexeddb, Web SQL and localStorage storage mechanisms supporting version migration, advanced query, SQL and transaction.
Apache License 2.0
503 stars 41 forks source link

data fetching in query problem #28

Closed aliabbas-2012 closed 9 years ago

aliabbas-2012 commented 10 years ago

No comment

yathit commented 10 years ago

50,000 on 6 or 7 stores is not a huge database. Query should get around 30 ms times.

You should store database only after database is connected. Also it is not necessary to wait document ready. Basically

db = new ydn.db.Storage('cqi', schema,options); 
db.onReady(function() {
   browserSql.create_physicians(all_physicians);
   browserSql.create_patients(all_patients);
});

Insert data as batch in array, if possible.

If database is encrypted, it is not possible to do query. Only CRUD and count methods are available.

Your get_list must return very fast, and should be less then 50 ms. Please measure how long does it take like:

  console.time('get_list-patients')
  db.from(table).list(10).done(function(items) {
    console.log(items); // 10 campers
    console.timeEnd('get_list-patients')
  });
yathit commented 10 years ago

I hate people talk (write) rubbish without support.

I asked you measured data to support your claim that my library is slow for 50,000 records. You fucking idiot. 50,000 records is not huge data size.

You don't understand database and now asking me solution. You don't not have enough skill to do your job. Be professional or find another job.

Best wishes, Kyaw

aliabbas-2012 commented 9 years ago

your are well well mannered guy , talk smoothly, it was a great to talk with you.